2011-10-12 (first published: 2011-08-31)
946 reads
Scripts
2011-10-10 (first published: 2011-08-24)
834 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,388 reads
2011-10-06 (first published: 2007-11-14)
1,936 reads
Using sys.dm_exec_requests to estimate completion time for a process
The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.
2011-10-05 (first published: 2011-09-09)
7,675 reads
Generating number sequences with Common Table Expressions
The script shows one of ways generating number sequence - this one uses CTE.
2011-10-04 (first published: 2008-02-06)
1,944 reads
Getting Age in Text or Date Difference in text format
This function returns the difference between the date in text format
2011-10-03 (first published: 2011-08-30)
1,035 reads
2011-10-03 (first published: 2008-03-27)
7,204 reads
Copy Multiple objects from One Schema to Another Schema
Copy Multiple objects from One Schema to Another Schema
2011-09-30 (first published: 2011-09-07)
1,550 reads
Function to Expand Tab Characters
A function to replace tab characters with the correct number of spaces to align the text as originally intended.
2011-09-29 (first published: 2007-10-11)
2,222 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
Alamat Kontak Bank BCA KCP Pati Telp:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers