This script creates a table named DATELOOKUP which is used for looking up date related values. Each record represents date related info about the date in the column dtDate. For example the iMonth column stores the integer value of the month of dtDate and sShortMonth stores the abbreviated name of that same month. Use this […]
2004-12-13 (first published: 2004-11-17)
233 reads
This SP takes a string to be searched as input parameter, loops through all tables, views, Sp-s in the database andreturns the name of the object it was found and number of occurences
2004-12-10 (first published: 2004-08-18)
692 reads
Simple script (alterable as needed) to verify existence of a file and execute a job if the return result = 1 (true)
2004-12-08 (first published: 2004-10-29)
149 reads
Updated Where_Am_I script to add database. This way you can park it in your master db and call it anytime you need it for another project/db.
2004-12-07 (first published: 2004-10-29)
178 reads
Is quite a joke, but useful, I guess, and, of course, improvable. It need to use two random number generator (inclued) published some weeks ago here.Some fieldtype needs to be generating-improved (e.g. images) ... I wait suggestions and improvements
2004-12-06 (first published: 2004-10-28)
354 reads
This script will update statistics on all user databases. The script can be created as a job from SQL Server Agent.
2004-12-03 (first published: 2004-10-27)
681 reads
This script finds the first day of previous, current and next month as well as last day of previous, current and next month.The calculation is based on the ISO date format which makes it independant of the date format used on the SQL Server.The calculation is performed from a date - it can be altered […]
2004-12-02 (first published: 2004-10-21)
278 reads
The following functions returns the number of years, months and days between two dates. The first returns a table format, and the second returns 1 value at a time
2004-12-01 (first published: 2004-10-13)
227 reads
Drops all the foreign keys in a database. This is useful when rebuilding data warehouses.
2004-11-30 (first published: 2004-10-13)
1,534 reads
I have a table named employees with an identity column named id. Also,last_name is a column in the table named employees. I created the employeestable and inserted 9 rows in it. If I do a select * from employees, theoutput looks like this:id last_name1 a2 b3 c4 d5 e6 f7 g8 h9 iThen I deleted […]
2004-11-29 (first published: 2004-10-13)
154 reads
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers