SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
808 reads
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
808 reads
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
1,569 reads
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-11-23
1,110 reads
At most large companies one business requirement is that all reports have the same look and feel. This may vary...
2009-11-20
12,540 reads
After several tries I think we finally have it working. If you were unable to attend the last two SQLLunches,...
2009-11-18
1,114 reads
When partitioning was first introduced in SQL Server 2005, I thought what a great idea. However, when I started reading...
2009-11-16
2,661 reads
Meeting URL: Join Meeting
Click the above Meeting URL around 11:30 AM CST on 11/16/2009 to join the meeting
Date: 11/16/2009
Time: 11:30...
2009-11-16
1,257 reads
This past Tuesday night I had the honor of speaking to a small group of college students who are all...
2009-11-12
778 reads
If you are in the Baton Rouge Area stop by and join our user group meeting this evening. The details...
2009-11-11
546 reads
Data Compression was introduced in SQL Server 2008. This feature helps compress data inside the database, thus potentially reducing the...
2009-11-10
714 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