October 30, 2008 4:53 AM
Posted by: Denny Cherry
SQLSo 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
Posted by: Denny Cherry
Query tuning,
SQLTake 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
Posted by: Denny Cherry
Federated Database,
In Person Events,
San Diego SSUG,
SoCal Code Camp,
SQLI'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
Posted by: Denny Cherry
END CONVERSATION,
Service Broker,
SQL,
SQL Server 2005,
TempDBI'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
Posted by: Denny Cherry
KB 250367,
MS DTC,
MSCS,
RPC,
SQL,
Windows 2008This 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
Posted by: Denny Cherry
Back To Basics,
Restore Database,
SQLThe 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
Posted by: Denny Cherry
KB 250367,
MS DTC,
MSCS,
RPC,
SQL,
Windows Server 2003Back in the Windows 2000 days, getting DTC to work was easy. It was setup by default to work. There wasn't a whole lot of configuration which needed to be done...
August 4, 2008 11:00 AM
Posted by: Denny Cherry
Config,
Encryption,
IPSec,
OpenSSL,
PGP,
Secure Data Transfer,
Secure FTP,
SFTP,
SQLYou'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
Posted by: Denny Cherry
Back To Basics,
BACKUP DATABASE,
SQL,
SQL Server 2000,
SQL Server 2005Now 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...
