2012-03-30
541 reads
2012-03-30
541 reads
2009-07-20
2,713 reads
a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.
2009-07-28 (first published: 2009-07-11)
819 reads
2009-04-10
3,969 reads
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
2009-03-04
3,485 reads
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
2008-12-30 (first published: 2008-12-05)
1,034 reads
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
2008-08-09
1,055 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,249 reads
Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.
2008-04-17
1,185 reads
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,261 reads
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;