DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
SITE SEARCH SQLUSA.com HEADLINES NEWS
SQL E/BOOKS  SQL 2012 PROGRAMMING  DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS

Microsoft SQL Server 2008
Administration Best Practices

How to put the SSIS Import/Export Wizard on Your Desktop?

How to import csv file with OPENROWSET?

How to list all table sizes in a database?

How to search all sprocs and views?

How to list disk drives with total and free space?

How to import flat file into staging table with numbering?

How to list all indexes in a database?

How to configure FILESTREAM on SQL Server 2008?

How to import Excel data with OPENROWSET?

How to test linked server connectivity?

How to list connection information for each session?

How to list all column defaults in a database?

How to disable all constraints and all triggers?

How to apply RESTORE checks on database backup files?

How to list all table row counts in a database?

How to check execution frequency for sprocs and views?

How to backup database with datetimestamp in file name?

How to list all tables with columns in a database?

How to mark a stored procedure for automatic startup execution?

 
Exam Prep 70-461
Exam 70-461
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE