<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Add a script
Items 1 to 20 of 2528
Next 20 >>
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
Read more...
By
David Kranes
2012/02/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
245 reads
a handy sysprocesses select
find what's running and at which point it's currently up to!
Read more...
By
Rik Thwaites
2012/02/01
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
1,044 reads
A google like search
A conceptual proof for a google like search procedure
Read more...
By
Jean Bulinckx
2012/02/02
|
Source:
SQLServerCentral.com
|
Category:
performance
Rating:
|
Discuss
|
Briefcase
|
817 reads
Insert new values in dimension avoiding deadlock
TSQL code deadlock-safe for inserting new value into dimension
Read more...
By
Federico Iori
2012/02/03
|
Source:
SQLServerCentral.com
|
Category:
dwh
Rating:
|
Discuss
|
Briefcase
|
356 reads
System Proc sp_SysMon to monitor sql server health
I created as a system proc but it can be executed individually. It will print some system health counters.
Read more...
By
Gokhan Varol
2012/01/31
|
Source:
SQLServerCentral.com
|
Category:
system health
Rating:
|
Discuss
|
Briefcase
|
825 reads
Data Driven Subscription - SQL Server Standard Edition
A simple example of using T-SQL and the Boomerang framework to create a data driven subscription.
Read more...
By
Michael Malmgren
2012/02/08
|
Source:
SQLServerCentral.com
|
Category:
reporting services (ssrs)
Rating:
|
Discuss
|
Briefcase
|
61 reads
Ensure Table Has Only 1 Row
How to maintain the Single row tables with out any coding,
Read more...
By
Praveen Kumar Peddi
2012/02/06
|
Source:
SQLServerCentral.com
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
152 reads
UDF_GET_NEXT_WEEKDAY
A simple way of getting the next weekday's dates...
Read more...
By
Praveen Kumar Peddi
2012/01/30
|
Source:
SQLServerCentral.com
|
Category:
dates
Rating:
|
Discuss
|
Briefcase
|
506 reads
Get next 1st thursday
Function to get the 1st thursday from the given day.
Read more...
By
Harsha Majety
2012/01/20
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
690 reads
Stored procedure to find and replace text in a text file
find and replace text in a text file using tsql
Read more...
By
Gene Hunter
2012/01/23
|
Source:
SQLServerCentral.com
|
Category:
string manipulation
Rating:
|
Discuss
|
Briefcase
|
1,779 reads
create jobs script for 2000 2005 or 2008
will create jobs script for backup or DR purposes to install on another server.
Read more...
By
Gene Hunter
2012/01/18
|
Source:
SQLServerCentral.com
|
Category:
jobs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,045 reads
Save all DTS packages
short script but another way
Read more...
By
Gene Hunter
2012/01/25
|
Source:
SQLServerCentral.com
|
Category:
dts
Rating:
|
Discuss
|
Briefcase
|
670 reads
Move DTS packages to another server
easy way to migrate DTS packages to another server
Read more...
By
Gene Hunter
2012/02/07
|
Source:
SQLServerCentral.com
|
Category:
dts
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
60 reads
SQL_Login_Password_Expiry_Notification
This store procedure will send a proactively mail about the SQL login name & there expiry date for which login which logins was applied for enforce the password policy
Read more...
By
Abhijit Shedulkar
2012/01/24
|
Source:
SQLServerCentral.com
|
Category:
sql login password policy
Rating:
|
Discuss
|
Briefcase
|
637 reads
Compression of all Objects
This script will compress all objects in the database.
Read more...
By
Gregory Ferdinandsen
2012/01/26
|
Source:
SQLServerCentral.com
|
Category:
compression
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
543 reads
Create bank holidays table
Do you know what happens if a holiday falls on a weekend? This script will help you.
Read more...
By
Scott Thomas
2012/01/16
|
Source:
SQLServerCentral.com
|
Category:
holiday
Rating:
|
Discuss
|
Briefcase
|
1,115 reads
Calculate the values for MAX Memory for SQL Server
Use this script to calculate MAX memory setting on a dedicated SQL server.
Read more...
By
Rudy Panigas
2012/01/27
|
Source:
SQLServerCentral.com
|
Category:
max memory setting
Rating:
|
Discuss
|
Briefcase
|
1,093 reads
Retornar campo separado por Pipe
A função retorna um campo dentro de uma lista separado por pipes
Read more...
By
Silvio Bedine
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
111 reads
Restore database from a device containing multiple backups
Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.
Read more...
By
Smitha Reddy
2012/01/04
|
Source:
SQLServerCentral.com
|
Category:
restore database
Rating:
|
Discuss
|
Briefcase
|
377 reads
Check SQL Agent Job Status
Useful for when you have something depending on the outcome of a job.
Read more...
By
Serge Mirault
2012/01/05
|
Source:
SQLServerCentral.com
|
Category:
agent
Rating:
|
Discuss
|
Briefcase
|
879 reads
Items 1 to 20 of 2528
Next 20 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
