MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-13
6,074 reads
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-13
6,074 reads
Reporting Services is a great tool for presenting data to users. However the changes in SSRS 2008 might cause you a problem after installation. New author Patrick LeBlanc has a solution you can try.
2009-10-08
7,839 reads
This past Friday I received a call from our systems team stating that they were running low on Disk Space...
2009-09-22
4,608 reads
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-14
2,313 reads
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
2009-08-19
1,759 reads
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-13
38,455 reads
The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...
2009-08-06
1,524 reads
Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification.
2007-10-10
15,153 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers