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 VIDEOS
 
 
SQL E/BOOKS   WORLD, USA & SQL NEWS   FORMAT
SCRIPTS SQL 2005 SQL 2008 ARTICLES
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
SQL 2016 DESIGN & PROGRAMMING
 
 
 
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