2004-04-22
4 reads
SQL Server 6.5
Measuring SQL Performance
One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.
2005-12-23 (first published: 2004-04-02)
36,328 reads
Help! My Database is Marked Suspect.
If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.
2007-09-22 (first published: 2004-03-31)
58,842 reads
Review of Review of SQL Server 2000 Administrators' Companion
Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.
2004-03-26
4,124 reads
Dump SQL Permissions
We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.
2004-03-17
18,155 reads
SQL Server Security Part 2
In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.
2019-10-04 (first published: 2004-01-30)
35,249 reads
Automatically Gathering Server Information Part 2
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-25
13,017 reads
2003-12-05
701 reads
Discuss Content Posted by Jeff Weisbecker
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Jeff Weisbecker
2003-11-16
7 reads
Discuss Content Posted by Deepak Arjun
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Deepak Arjun
2003-10-31
3 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers