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 2014 PROGRAMMING   DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
How to perform selected administration & programming tasks?

Execute the following Microsoft SQL Server T-SQL scripts to perform various actions:

-- Estimate tempdb space for CHECKDB

DBCC CHECKDB(AdventureWorks2008) with ESTIMATEONLY

------------

 

-- DROP Windows login from SQL Server

USE master;

EXEC sp_revokelogin 'FinanceNET\jsmith'

------------

 

-- CHANGE database recovery model

ALTER DATABASE AdventureWorks2008 SET RECOVERY SIMPLE

-------

 

-- SQL Server 2000 - pin frequently used table into memory

-- You have to have sufficient memory to use this feature

use pubs

DECLARE @db_id int, @tbl_id int

SET @db_id = DB_ID('pubs')

SET @tbl_id = OBJECT_ID('pubs..authors')

DBCC PINTABLE (@db_id, @tbl_id)

------------

 

-- Find all foreign keys pointing to / referencing this table PK

USE AdventureWorks2008;

EXEC sp_fkeys @pktable_name = N'Product'

    ,@pktable_owner = N'Production'

/* Partial results

FKTABLE_QUALIFIER FKTABLE_OWNER     FKTABLE_NAME      FKCOLUMN_NAME

AdventureWorks2008      Production  BillOfMaterials   ComponentID

AdventureWorks2008      Production  BillOfMaterials   ProductAssemblyID

AdventureWorks2008      Production  ProductCostHistory ProductID

AdventureWorks2008      Production  ProductDocument   ProductID

*/
------------

 

Related links:

Rename File with Date Suffix

 

Get List of Files in a Folder/Directory

 

 

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