2008-12-02 (first published: 2008-10-30)
1,430 reads
Scripts
Get SQL Server 2005: Details about running or defined traces
This provides information about traces that are defined on SQL Server 2005.
2008-12-01 (first published: 2008-10-25)
1,285 reads
SQL 2005 Get Roles, Schemas & Object Permissions
Pulls all DB/Server fixed roles, default schemas & object permissions for all logins
2008-11-28 (first published: 2008-10-25)
2,402 reads
How to Drop Unused Empty Redundant columns
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
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
AUTOGENERATE INSERT UPDATE SELECT STATEMENTS
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,835 reads
AUTOGENERATE Stored procedures example
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
754 reads
2008-11-20 (first published: 2008-10-06)
975 reads
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
291 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers