This Stored Procedure Will Get: - The Data and Log File Names - The Data and Log File Sizes (MB) - The Data and Log Percent Utilization (%) for ALL Databases on a SQL Instance. Numbers Should (More Or Less) Reflect What You See on The SQL Enterprise Manager Taskpad. LIMITATIONS: For Databases With Multiple […]
2005-02-14 (first published: 2005-01-13)
1,183 reads
Imports data from MySQL Server; works best with mysql driver 3.51.06! You'll have to create a dsn and then a linked server to that dsn. The script checks if the table exists in the mysql catalog (defined in the dsn properties). Too bad it needs administrative privileges to run (dbcc statement) - my advice: don't […]
2005-02-11 (first published: 2005-01-17)
141 reads
Kmlakov's script, t-sql function to parse string data, posted on 1/19/2005, required the passing in text ends with the delimiter. But it is usually not the case. I rewrote the script (added one IF statement). The new script can treat the text with or without ending delimiter. The third parameter will be the number of […]
2005-02-07 (first published: 2005-01-19)
397 reads
2005-02-01 (first published: 2005-01-06)
162 reads
This script will get you the current date minus the time. It will display all zeros instead.DATETIME is stored as a number in SQL and less internal conversions are will be used then other methods. Microsoft generally uses this method.
2005-01-31 (first published: 2005-01-06)
253 reads
Shows database, table names which are locked, the user who locks them, the command which is executed
2005-01-28 (first published: 2005-01-06)
1,156 reads
SQL Server's Reporting Services comes with some pre-built reports to be able to monitor who is doing what with your Reporting Services Server. You can find these reports in the \Extras\Execution Log Sample Reports folder on the product CD-ROM (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp). One of the reports is titled "Todays Reports" (Todays Reports.rdl/pToday Dataset). It should show the […]
2005-01-27 (first published: 2005-01-07)
903 reads
This is a very cool time saving ActiveX Script, run manually from within DTS Designer, that generates date and sequence named backups of the package into the specified development and backup folders. Don't ever lose work again.
2005-01-26 (first published: 2005-01-08)
115 reads
I have found that I can add wildcard support to the Advanced Search Stored Procedure submitted by jgroseth (Posted: 07/02/2004) here:http://www.sqlservercentral.com/scripts/contributions/1201.aspby simply modifying "charindex( c.string," to "patindex('%' + c.string + '%'"I did this to take varying whitespace into account since SQL server does not care about whitespace, for example "INSERT INTO DATABASE_MYTABLE" could have any […]
2005-01-25 (first published: 2005-01-10)
523 reads
Here's a short script to generate a random alphanumeric string based on newid(). The procedure takes in length (@len) which determines the key length. Length must be between 8 and 32. Result is returned in an output parameter. A test script is supplied.
2005-01-24 (first published: 2005-01-10)
1,292 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Hi, Do you know if there is a way to get more detailed logging...
Comments posted to this topic are about the item Four Rules for Adding AI...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers