SQL Server with Mr. Denny:

Development


October 30, 2008  4:53 AM

VMware Windows XP x64 LSI Driver



Posted by: Denny Cherry
SQL

So yesterday I was asked to setup a few x64 workstations on our ESX server. The Vista x64 machines detected the LSI controller no problem, but the Windows XP machines couldn't find the controller, and the drivers that VMware included with ESX (3.0.2) were x86 only drivers.

October 13, 2008  11:01 AM

Why is my SELECT COUNT(*) running so slow?



Posted by: Denny Cherry
Query tuning, SQL

Take a look at the execution plan for your query. You'll notice that the query is doing an Index Scan (or a table scan), not an Index Seek which is why the SELECT COUNT(*) takes so long. The reason for this is that the COUNT(*) function needs to look at every record in the table. As a workaround...


September 19, 2008  7:04 PM

Great Turnout At the San Diego SQL Server Users Group Last Night



Posted by: Denny Cherry
Federated Database, In Person Events, San Diego SSUG, SoCal Code Camp, SQL

I'd like to say thanks to the San Diego SQL Server Users Group for inviting me to speak last night. I had a great time speaking to the group, and just like last time the questions were all excellent. The slide...


September 11, 2008  11:00 AM

Service Broker may not remove messages after processing



Posted by: Denny Cherry
END CONVERSATION, Service Broker, SQL, SQL Server 2005, TempDB

I've seen an issue with Service Broker that others may be seeing.  Messages are sent into the service broker, and are processed as normal, and they are removed from the message queue.  However you still see the conversation in the sys.conversation_endpoints DMV in a CONVERSING state instead of a...


September 8, 2008  11:00 AM

How to configure DTC on Windows 2008



Posted by: Denny Cherry
KB 250367, MS DTC, MSCS, RPC, SQL, Windows 2008

This post is specifically about setting up DTC on Windows 2008.  If you are looking for the post about setting up DTC on Windows 2003 you'll want to go to the post "


August 11, 2008  11:00 AM

Back To Basics: The RESTORE DATABASE Command



Posted by: Denny Cherry
Back To Basics, Restore Database, SQL

The restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command.  The syntax of the RESTORE DATABASE...


August 7, 2008  11:00 AM

How to configure DTC on Windows 2003



Posted by: Denny Cherry
KB 250367, MS DTC, MSCS, RPC, SQL, Windows Server 2003

Back in the Windows 2000 days, getting DTC to...


August 4, 2008  11:00 AM

I need a secure transfer of data between SQL Servers. What are my options?



Posted by: Denny Cherry
Config, Encryption, IPSec, OpenSSL, PGP, Secure Data Transfer, Secure FTP, SFTP, SQL

You've got a few options, none of which are all that easy to setup. 1. Export the data, then encrypt the file, then transfer the file, then decrypt the file, then import the file. 2. Setup IPSec between the two SQL Servers and then transfer the data as normal. 3. Setup a Secure FTP Server at...


July 22, 2008  11:00 AM

Back to Basics: The BACKUP DATABASE command



Posted by: Denny Cherry
Back To Basics, BACKUP DATABASE, SQL, SQL Server 2000, SQL Server 2005

Now that you have objects created within your database, and data within the tables you need to secure your database in case of a server failure or accidental data deletion.  This would be done by taking backups of the database.  Backups are taken by using the BACKUP DATABASE command. The...


July 21, 2008  11:00 AM

A better way to index text data



Posted by: Denny Cherry
Index Performance, Query tuning, SELECT statement, T/SQL, Tables, Uni-code

Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for.  However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server.  This is because of the large amount of data being put in...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: