2001-07-02
4,052 reads
Articles
SQL Server 7.0 Log Shipping Frequently Asked Questions
This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.
2001-07-02
1,764 reads
Find The First Row
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
2001-06-29
12,629 reads
Microsoft Certification Exams Included in VA Education
Microsoft Corp. today announced that veterans taking tests in the Microsoft® Certified Professional (MCP) program can now use their Department of Veterans Affairs (VA) education benefits to cover examination fees (May 23, 2001).
2001-06-29
4,208 reads
Using Stored Procedures from ADO 2.1
If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever.
2001-06-29
1,967 reads
Multiple paths in DTS Workflow
This article shows you how to create multiple converging paths in workflow, and covers the use of a simulated OR constraint, not available directly from within the designer.
2001-06-28
990 reads
Missing Temp Tables - Follow Up
Two weeks ago Andy challenged the readers of SQLServerCentral.com to figure out a small puzzle. Come see the results for yourself and find out who won some cash!
2001-06-27
4,852 reads
Undocumented T-SQL Tricks With Logs
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
2001-06-27
14,812 reads
2001-06-26
2,789 reads
Optimizing SQL Server Performance Using Files and Filegroups
Learn how to boost the performance of SQL Server by making proper use of filegroups.
2001-06-26
1,774 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
A Guide to SQL Security in Django
Comments posted to this topic are about the item A Guide to SQL Security...
I Need a CS Degree. I Don't Need a CS Degree
Comments posted to this topic are about the item I Need a CS Degree....
Incremental Statistics
Comments posted to this topic are about the item Incremental Statistics
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers