datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS
SQL Server Tutorial Training Scripts

SQL Server Best Practices

Most Popular How To Topics
How to convert from string to datetime?
How to build and execute dynamic SQL queries?
How to use the ISNUMERIC & CASE functions?
How to create a new table with SELECT INTO?
How to calculate percent on base?
How to pad a string with leading zeros?
How to create a covering index?
How to use the SSIS Import/Export Wizard?
How to configure hard disks for optimal performance?
How to configure memory for optimal performance?
How to remove time part of datetime?
How to prevent parameter sniffing?
How to eliminate duplicates in a table?
How to identify deadlock processes and prevent deadlocks?
How to design an INSERT SELECT query?
How to purge data into history table?
How to create a server-side trace from a stored procedure?
How to generate RUNNING TOTAL column?
How to use CASE for report formating?
How to do update from two tables?
How to page in large result set?
How to create and apply table-valued functions?
How to comment a stored procedure?
How to use the MERGE statement instead of UPDATE?
How to generate index fragmentation report for all the indexes?
How to use select from select and correlated subqueries?
How to obtain quick counts of rows in all tables?
How to reindex fragmented tables in a database?
How to import & export image column data?
How to use SARGable predicate in a WHERE clause?
How to use LEFT JOIN in queries?
How to compare temporary table vs table variable speed?
How to capture IDENTITY values assigned in INSERT?
How to implement T-SQL complex sorting?
How to sequence subsets in result?
How to build UDF CHECK constraint?
How to test column for PRIMARY KEY constraint?
How to update large table with millions of rows?
How to use COALESCE and ISNULL?
How to change the collation of a column?
How import and export document column data?
How to build LEFT JOIN - RIGHT JOIN query?
How to build calendar table for a month?
How to use the FORMAT function?
How to store TIME only in a table?
How to architect a WHILE loop using table variable?
How to obtain pricing and licensing information?
How to measure query complexity?
SQL Server 2012 New Features

 
SQL Server IT Career Powering Scripts
How to find the TOP 10 pages on sqlusa.com website?
How to set the default language and default database for a login?
How to use self-joins?
How to architect a WHILE loop using TOP?
How to calculate days in a month?
How not to use triggers?
How to find files with the xp_fileexist command?
How to create a stored procedure for DTSRUN?
How to find unique indexes in a database?
How to apply identity for row sequencing?
How to find the login name of the dbo?
How to "fingerprint" a database quickly?
How to grant execute permission on all sprocs?
How to connect to a SQL Server database from ASP?
How to access database metadata?
How to construct a delay loop for simulation?
How to perform selected administration & programming tasks?
How to create a csv list for groups?
How to parse out filename from path?
How to query the default trace file?
How to change ownership for a set of stored procedures?
How to backup a database with OSQL and SQLCMD?
How to eliminate trailing spaces in a column with RTRIM?
How to apply nested CONVERTs for complex data conversion?
How to create login for SQL Server?
How to use the CASE function for report formatting?
How to simulate a casino roulette?
How to use derived tables to build complex queries?
How to apply table-valued function for sales reporting?
How to rename all tables in the database?
How to read an environment variable?
How to delete duplicates in a table?
How to limit updates on a table?
How to reinstall SQL Server?
How to apply correlated subquery with averaging?
How to prevent table lock escalation?
How to create VIEWs for low and high-priced products?
How to email reports using xp_sendmail?
How to list the columns in all of the tables?
How to create a comma-delimited list with COALESCE?
How to check what service pack is installed?
How to find the minimum of two numbers?
How to find all orders with 10% discount?
How to number with a CURSOR loop?
How to form correlated SELECT list item?
How to turn on SHOWPLAN?
How to use the DATALENGTH function?
How to use UNION ALL instead of or?
How to list the last backup date for all databases?
How to resolve PRIMARY filegroup full error?
How to execute a distributed TRANSACTION?
How to set up a restaurant inventory check constraint?
How to fillin missing data with a trigger?
How to obtain the date only part of a datetime column?
How to imbed apostrophe inside a string?
How to reset a suspect database?
How to sequentially number the result set?
How to grant execute permission to a role on all sprocs?
How to execute a cmd file?
How to use DBCC OPENTRAN?
How to SELECT without column names?
How to construct a four table INNER JOIN SELECT?
How to insert into an Excel spreadsheet?
How to find out the last backup dates of all databases?
How to search all stored procedures?
How to find non-matching rows in two tables?
How to create a sequence column for the result set?
How to export and import text column data?
How to change user defined data type?
How to parse a string with complex CHARINDEX?
How to backup a terrabyte database to tape?
How to resolve "SQL Server does not exist or access denied"?
How to import an image into a table?
How to find all the triggers in a database?
How to join to an Access table?
How to get file information?
How to pass encrypted password to DTSRUN?
How to link to an Oracle database server?
How to remove users from a database?
How to check the integrity of a database?
How to use the Boolean / bit data type?
How to get rolling 30 days of data?
How to store pictures in the database?
How to copy a database to a different server?
How to determine the number of reads in a stored procedure?
How to INDEXDEFRAG during daytime?
How to use the timestamp data type?
How to avoid using substring in a WHERE clause?
How to find the highest paid employee in each department?
How to sort on a date column?
How to add identity column to a table?
How to resolve deadlock resolution victim situtation?
How to avoid using NULLs?
How to make developers love normalized database?
How to name the primary key of a table?
How to use the Hungarian convention in naming database objects?
How to see triggers in a database?
How to check if an index is deteriorated?
How to get random results from SELECT?
How to name user-defined functions?
How to get into the system when locked out by Management Studio?
How to check indexes on a table?
How to create an insert statement for a table with many columns?
How to display all objects in a database?
How to use the CHECKPOINT statement?
How to pronounce SQL?
How to put a database into single-user mode?
How to diagnose in crisis situation?
How to join tables with different collation?
How to stop SQL Server with command?
How to eliminate NULLs?
How to reseed the identity value on a table?
How can I tell the object type in the sysobjects table?
How to find the server version?
How to avoid using SELECT * FROM?
How to create a fast clustered index on a table?
How to find street name in address?
How to avoid using INSERT without column list?
The Best SQL Server Training in the World

 
Exam Prep 70-461
Exam 70-461