2008-08-05 (first published: 2008-06-12)
3,434 reads
2008-08-05 (first published: 2008-06-12)
3,434 reads
2008-06-12
3,526 reads
2008-05-23
4,518 reads
I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.
2008-05-21
3,165 reads
Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.
2008-05-15
2,960 reads
2008-05-08
3,798 reads
Learn what a Dates table is and how to create one, and then try it out for yourself
2008-05-06
5,831 reads
2008-05-01
3,658 reads
2008-04-30
3,646 reads
2008-04-28
4,633 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers