Get the all the SQL Server related services information
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,243 reads
This SP will be create C# classes using all table
This SP will be create C# classes using all table in the specified Database
2007-11-13 (first published: 2007-09-04)
2,485 reads
2007-05-07 (first published: 2007-04-20)
222 reads
Default Constraints with PRINT or DROP
To Retreive List of Default Constraints from current database with PRINT or DROP
2007-05-04 (first published: 2007-04-20)
524 reads
List of RTA numbers based on the lucky number you
Using this procedure you can get the list of 4 digit number and the sum of those 4 digits is equal to your given input number. its helpful when you choose your RTA (Regional Transportation Authority) Vehicle number.Input For this procedure: Single Digit Number (May be your luck number)Output From this procedure: it gives the […]
2007-04-04 (first published: 2007-03-03)
80 reads
Blogs
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Convert date value
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Partitioning table techniques which one is best way?
Hello All, I am about to do partitioning for my DW tables based on...
MAXDOP and cost threshold for parallelism settings
Hi All, On one of our newly migrated sup-prod azure vm which is running...
Ask SSC