Lots of Tables and a Little DMO
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?
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?
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.
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.
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.
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!
This is a follow up article on the database comparison they did about 18 months ago.
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.
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
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.
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.
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers