SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost
Profile: Denny Cherry
I was asked...
0 Comments
RSS Feed
Email a friend
You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server
Profile: Denny Cherry
SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren't compatible. You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won't be able to be deployed to the SQL 2005 report server. With enough major editing of the SQL 2008 report you can convert it...
10 Comments
RSS Feed
Email a friend
How to setup SQL 2008 BIDS to use VB.NET as the default scripting language
Profile: Denny Cherry
If you are like me and don't know anything about...
0 Comments
RSS Feed
Email a friend
Back to Basics: The BACKUP DATABASE command
Profile: Denny Cherry
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...
3 Comments
RSS Feed
Email a friend
A better way to index text data
Profile: Denny Cherry
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...
6 Comments
RSS Feed
Email a friend
Book: The Windows Manager’s Guide to iSCSI SANs
Profile: Denny Cherry
That's right I said a book. Well it's actually an eBook but good enough right? The best part is that it's available for free. It's a three chapter eBook called "The Windows Manager's Guide to iSCSI SANs". Each chapter was posted separately so you have to click through to each...
0 Comments
RSS Feed
Email a friend
Using batching to do large operations without filling the transaction log
Profile: Denny Cherry
Deleting large amounts of data from a table is usually an important task, but if you don't have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database. Not to mention you will cause a very large amount of...
2 Comments
RSS Feed
Email a friend
My Experience with putting a CRL Procedure into SQL
Profile: Denny Cherry
A little while ago I came upon a situation where I needed to put a CRL procedure into SQL Server 2005. Now I've been using SQL Server 2005 since the day it went RTM, and this is the first occasion that I've needed to put a CLR procedure into SQL. Could I have done what I needed to without a CRL...
0 Comments
RSS Feed
Email a friend
SQL 2008 RC0 Intellisense doesn’t work against SQL 2005
Profile: Denny Cherry
I've been working with SQL 2008 RC0 for a couple of weeks now, and something I've...
1 Comment
RSS Feed
Email a friend
Back To Basics: The RECEIVE command (and END CONVERSATION)
Profile: Denny Cherry
The RECEIVE command is the last of the Service Broker items to cover in the Back To...
0 Comments
RSS Feed
Email a friend