Certification Tips
This article by Andy Warren offers some suggestions to help you get ready for your first Microsoft exam.
2002-06-21
6,633 reads
Articles
Challenge the Community
Have a SQL Server question? Challenge the largest SQL Server online community in our forums! If you think your a guru, test yourself by helping a newer DBA. SQLServerCentral.com has active forums with over 100 posts daily.
2002-06-21
14 reads
Become an Author!
Want to be an author and be admired by the SQL Server community? Find out more details about how to be a writer for SQLServerCentral.com, visit this page.
2002-06-19
32 reads
The Microsoft SQL Server™ Accelerator for BI Launched
The Microsoft SQL Server™ Accelerator for Business Intelligence (SQL Server Accelerator for BI) makes it easy to build a customizable business intelligence solution from your operational data, enabling your organization to realize the power of business analytics.
2002-06-19
4,470 reads
Review of COMCompare by Red Gate
Andy takes a look at the third product in the popular bundle from Red Gate that does comparisons of COM components. Looks like it's easy to use and a nice tool to have around!
2002-06-18
2,900 reads
Creating your own sp_MSforeach stored procedure
This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.
2002-06-17
16,329 reads
Yukon Resource Center Launhced
This week, SQLServerCentral.com launched its Resource Center all about getting a sneak peak on Yukon. All links are user contributed.
2002-06-14
13 reads
SQLServerCentral.com Launches SQL Server Security Analzyer
SQLServerCentral.com launched its first online free software, which can evaluate your SQL Server remotely and look for SQL Server security vulnerabilities. This free service looks for weak or no passwords and does a basic penetration test online.
2002-06-13
46 reads
Updated Freeware Product SQLExecMS Released
Oleg Dantchenko has updated his very successful freeware product, SQLExecMS to release 1.5. The new release has a new look, more features and is perfect for rapid development and quick DBA work.
2002-06-12
50 reads
2002 SQL Server Best of Breed Product Nominations
Welcome to the first SQLServerCentral.com SQL Server Best of Breed Product Awards. These awards allow you to reward the products that you feel are the best in the SQL Server industry. These awards are user nominated and users vote for the winners.
2002-06-10
13 reads
Blogs
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
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...
Forums
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
A Few Good DBAs
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
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