Full and Differential Backup of Select Databases
Full and Differential Backup of Select Databases with Calculating Disk Space and Checking if a Database is in Use With Selections
2005-06-28 (first published: 2005-05-27)
655 reads
Scripts
Monitoring and logging Reportserver
This Stored Procedure gives you live information of the workload on the reportserver and information about who uses wich report and how often a report is startedA report based on this SP with a short refresh time gives you a live monitoring tool.
2005-06-24 (first published: 2005-06-01)
445 reads
Drop foreign keys from a database
This script will drop all of the foreign keys on user tables in the database it is executed in. This is useful as a pre-load process.
2005-06-22 (first published: 2005-05-23)
843 reads
Ccreate xls file based on the query passed
procedure will create xls spreassheet file based on the query passed and put it into the designated folder
2005-06-21 (first published: 2005-05-24)
1,044 reads
Move a table between filegroups
Sorry fellas but Red-gate bought the site and now claims all copy-rights for its content, so I deleted this script. You can find it in other sites throughout the internet, such as http://education.sqlfarms.com/ShowForum.aspx?ForumID=20
2005-06-16
1,055 reads
Return WeekNo (ISO 8601 standard)
In MS SQL, January 1 of any year defines the starting number for the week. The DATEPART(wk, 'Jan 1, xxxx') always return 1. However, a lot of reports Week No is actually based on ISO 8601 standard, that is January 1 of any year can be Week 53/52 or Week 1. (http://www.merlyn.demon.co.uk/weekinfo.htm#IDC)The Rule is as […]
2005-06-14 (first published: 2005-05-27)
333 reads
Display Table and Index Space Allocation
This script adds to others posted on this site by formatting and displaying text information about table and index space allocation.
2005-06-13
457 reads
IsDateAHoliday UDF
This is a User Defined Function that returns a 1 if date is a holiday else, it returns a 0.The holidays are:New years Day, MLK Day, Presidents Day, Memorial Day, Independance Day, Labor Day, Columbus Day, Veterans Day, Christmas Eve and Christmas Day
2005-06-13 (first published: 2005-05-27)
324 reads
Another Data Paging
Makes a paged query with the sql parameters to build itand page parameters to filter.Add "No","CurrentPage","TotalPages" coumns to the queryto manage paging at user interface.The query Lose the identity column orderIt works fine for me!
2005-06-12
189 reads
Avoid Divide by Zero Errors
A simple User Function which will guarantee always to return a value from a division without any errorsExample : GPDivNErr(@Val1 float, @Val2 float)
2005-06-10 (first published: 2005-05-29)
497 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers