DBCC page was decommissioned in 7.0 according BOL. Parameters have being changed, but the call itself remains. Following script shows some reverse engineering results.
2007-06-25 (first published: 2006-05-29)
425 reads
This is a first version of a custom solution for SQL Server log shipping using VB.NET 2005 and .NET Framework v.2.0. The script has to run on a server where you have SQL Server 2005 (or at least tools) installed because it uses new SMO. For some functions of the script you will have to […]
2007-06-22 (first published: 2006-06-05)
1,140 reads
Hi,exec sp_change_users_login 'report' displays the list of orphan USERS in a database but we don't have any builtin SP which displays the orphan LOGINS.By Orphan Logins (not users), I mean the Logins that don't have any access to any databases and are sitting idle on the server (also aren't member of any fixed server role).We […]
2007-06-21
276 reads
A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]
2007-06-21 (first published: 2006-01-30)
299 reads
Some time back i had the requirement for a SP which will give non repeatable random numbers with in a range. Following SP accepts a range and gives the random numbers. Once the numbers are exhausetd NULL, will be the out put. In this case user can restart the random number generation by passing 1 […]
2007-06-20 (first published: 2006-03-29)
248 reads
Use this Perl script to add Enterprise Manager registrations from a text file. The text file should contain three fields seperated by spaces. The first two fields are the server groups you want to create, and the last is the server name. ex...Production Accounting ACTPRSQL01QA Accounting ACTQASQL01The script also goes out and registers all SQL […]
2007-06-19 (first published: 2005-03-23)
301 reads
This script will give detials for all the enabled job including their steps/command/schedule.
2007-06-18 (first published: 2006-05-26)
896 reads
This is my attempt to improve the performance of propercasing a string of text in SQL server. I have run this against several other "looping constructs" - and it is significantly faster.
2007-06-15 (first published: 2005-10-17)
433 reads
This script creates 2 new system functions :fn__testregexp(@String,@Pattern) returns int execute the method test(@String) on the regular expressions @Pattern returns : 0 : no match 1 : match null : one of the parameters was null anything else : error from sp_OA procedure fn__replaceregexp(String,@Pattern,@Replace) returns varchar execute the method Replace(@String,@Replace) […]
2007-06-14 (first published: 2004-04-07)
1,925 reads
Hello,I posted this a while ago to several web sites. Someone found an obscure bug in it and I fixed it (newest script attached below). When I posted it to you last time, it didn't show up in any of the categories that I had checked; hmmmm? However, when I searched google, you have it […]
2007-06-13 (first published: 2004-09-28)
1,856 reads
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
WA:08218154393 Jl. Majapahit No.112, Pandean Lamper, Kec. Gayamsari, Kota Semarang, Jawa Tengah 50161
WA:08218154393 Ungaran Square, Jl. Gatot Subroto Blok A3-A4, Banaran Barat, Bandarjo, Kec. Ungaran Bar.,...
Comments posted to this topic are about the item The SQL Server 2016 Plan
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers