Andy discusses a recent thread where a reader has very slow login tables with 2000 tables. After writing some DMO code (very handy by the way) and creating some objects, he can't track it down. Have any ideas?
2003-07-30
7,124 reads
Freeware! This add-in gives you some great extra features when working in VB6. It has a tab index setter, options to add a chunk of error handling code, a simple code analyzer that gives you some metrics, and my favorite - an option to identify unused code and variables. If you're still using VB6 it's worth trying.
2003-07-30
1,541 reads
This article shows how to create a trace and capture it into a table using a combination of SQL and VBScript. Direct and to the point, you can read this and try it easily.
2003-07-29
9,122 reads
Where should SQL Server go in the future? What enhancements are needed? Steve Jones starts to explore his wish list for future versions of SQL Server.
2003-07-28
8,012 reads
Bad data is almost a given, but true duplicate data can really cause you some headaches. How do you remove all the duplicates and still leave a 'keeper' record? If you think procedural code it's not too hard, but can you do a set based solution? Chris shows you show!
2003-07-25
20,008 reads
This is a follow up article on the database comparison they did about 18 months ago.
2003-07-24
604 reads
New author! This article has a stored procedure that will generate an HTML document - as long as the table has the proper schema. If you try it, be sure to download the associated zip which has some images and the script for the stored procedure.
2003-07-23
7,784 reads
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
2003-07-22
19,620 reads
New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.
2003-07-21
12,770 reads
Everyone uses a text editor. Whether for programming, editing configuration files, or reviewing logs. Here's a look at an inexpensive replacement for notepad that performs a number of functions that DBAs might be interested in having.
2003-07-18
8,339 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
Comments posted to this topic are about the item Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers