2008-12-02 (first published: 2008-10-30)
1,430 reads
2008-12-02 (first published: 2008-10-30)
1,430 reads
This provides information about traces that are defined on SQL Server 2005.
2008-12-01 (first published: 2008-10-25)
1,285 reads
Pulls all DB/Server fixed roles, default schemas & object permissions for all logins
2008-11-28 (first published: 2008-10-25)
2,402 reads
Often during the development lifecycle columns are added to tables that become redundant or remain unused.
this script removes unused (empty) columns
2008-11-27 (first published: 2008-10-22)
1,187 reads
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,273 reads
2008-11-25 (first published: 2008-10-20)
1,326 reads
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,835 reads
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
755 reads
2008-11-20 (first published: 2008-10-06)
975 reads
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
291 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp: 0817839777 Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
hi , a new user wants to be able to add sql agent jobs...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers