SQL Maintenance Plans - Under the Covers!
In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!
2002-05-21
9,308 reads
Articles
Designing a Flexible Task Management Database
In this article by Jamie Voss, he shows the methodology he used to develop his task management database.
2002-05-20
6,344 reads
SQL Security Resource Center Opens
SQLServerCentral.com is proud to launch it's first Resource Center for security. It's a one-stop shop for anything related to SQL Server security. All content is user-contributed and contains links to content throughout the web.
2002-05-20
68 reads
Freeware Product : ASPReport
It provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the report parameters - all through the web interface. Members can now download this as Freeware at SQLServerCentral.com.
2002-05-16
115 reads
Understanding Your Identity
Is the Identity property part of a transaction? I always thought so, but decided to test it and see what happens.
2002-05-16
4,565 reads
2002-05-15
2,955 reads
How Dynamic SQL Can Be Static SQL Part 2
This article shows you how to use the CASE function to design single query solutions that have changing results depending on the values you assign to variables. These techniques are extremely useful as alternatives to dynamic SQL.
2002-05-14
10,823 reads
Version Control for Stored Procedures
Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
2002-05-10
13,451 reads
Get Your Free DTS Poster
SQLServerCentral.com has crossed 40,000 users! Thanks for all of you telling your friends about our site and making us a strong SQL Server community. To thank you, you can request to receive a free DTS object model poster that we worked on in conjuction with Lumigent. To sign up to get your hard copy, go to http://www.lumigent.com/go/sqlcentral05
2002-05-10
3,336 reads
2002-05-08
3,242 reads
Blogs
Monday Monitor Tips: Projecting Disk Space
By Steve Jones
One of the things that many DBAs struggle with is managing space across an...
SQL from A to Z: Your Path to SQL Mastery this Fall
I'm excited to tell you about the "SQL from A to Z" learning track....
Introduction to Advanced Analytics
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem, which...
Merge rows in SQL
I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...
Blocking Connection to Server
Good Afternoon, We recently procured a service management software for our company, which uses...
Question of the Day
AUTO_DROP Statistics
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers