The following script performs log, differential or full backups of a single, or all databases on your SQL Server. It then copies or moves the file(s) over to a network share drive. It also removes old backups from both locations if needed. Don't forget to set the local drive path and network share for each […]
2007-09-14 (first published: 2007-05-16)
19,202 reads
We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/
2007-09-14
3,844 reads
This script was designed to restore a backup of a SQL Server 2000 database from disk file to SQL Server 2005.Unfortunatelly the RESTORE will leave land mines for you to find the hard way, this script was updated to fix all that I have found:Change CONCAT_NULL_YIELDS_NULL ON, PAGE_VERIFY CHECKSUM, Compatibility level to 90, remove the […]
2007-09-14
4,544 reads
This is a simple script that when used by command-line OSQL/ISQL can help you locate a stored procedure.How many times have you been looking for stored procedure code and could not find it? This is a simple method to locate lost code.When you manage many database servers this can become a common problem. The scenario […]
2007-09-14
2,127 reads
Quite often I need to cut off the first (or last) few characters of a string. To do just that I created two functions LSTR() and RSTR().Syntax: LSTR( @stringtocut, @length )Note: @stringtocut is trimmed in the functionWhen @length is equal or larger than zero, this function performs the same as LEFT( LTRIM(RTRIM(@stringtocut)), @length ).When @length […]
2007-09-13
1,619 reads
2007-09-13 (first published: 2007-05-16)
347 reads
Hi this is my first post on sql....The below procedure will check the current errorlog(past one hour errorlog will be scanned)for the keyword "error" (you can include your own key word) .. If you run the procedure it will look for keyword error in the past one hour... it will be use full for some […]
2007-09-12 (first published: 2007-05-06)
775 reads
2007-09-11 (first published: 2007-05-03)
595 reads
This improved Split function allows for multi-byte delimiters, optional null values, and optional null value substitution.
2007-09-10 (first published: 2007-05-01)
484 reads
Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]
2007-09-09
3,725 reads
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Your AI is busy. But do you know what it's worth? Most companies can...
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
Jl. Kemanggisan Utama Raya No.37, RT.7/RW.8, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus...
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers