The Ultimate Precompiled Procedure Searcher
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
2009-10-08 (first published: 2008-06-20)
1,885 reads
sys.sql_modules
RE: Backup Debate...
We have a db that was 50GB of data. Went to Litespeed, shrank to 8GB. Time went from over an hour to under. I'd get Litespeed and run it to disk, then to tape. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-27
1 reads
RE: date format
SQL Internal Datetime: datetime Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds). Values are rounded to increments of .000, .003, or .007 seconds, as shown in the table. Example: Create Table Test(ColA datetime,COlB datetime) GO […]
2003-06-25
1 reads
RE: job schedule doesn't work well
Run one step at a time to find out which step are causing the problem and post the script/SP of that step here see whether we could help out.
2003-05-22
1 reads
Blogs
THAT Conference 2024 in Wisconsin Dells
By Steve Jones
I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is...
7 Best Online Advanced SQL Training Courses to Learn in 2024
The world runs on data, and SQL is the key to unlocking its secrets....
Calling a REST Endpoint from Azure SQL DB
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers