How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including
the TOP statement. Consider the followong attempt...
2010-03-16
797 reads
Blog Posts
Intel Xeon 56xx Series Westmere-EP Review
AnandTech IT has a quick review of the upcoming six-core, 32nm Intel Xeon 56xx processor, which includes several different database...
2010-03-16
1,948 reads
PASS Update #26 (Bylaws & Upcoming Board Meeting)
Most months we do a conference call, but a couple times a year we get to meet in person and...
2010-03-16
594 reads
Return the Value of a Specified Dataset Row Outside a Data Region
I want to return the field value for a specific row to a textbox below a table in
my report. To...
2010-03-16
428 reads
SQL Saturday #33 Recap
SQL Saturday #33 was held on Saturday, 3/6, at the Microsoft campus in Charlotte. Hosted by the Charlotte SQL Server...
2010-03-16
1,060 reads
SQL Saturday is a’comin!
Just a quick reminder that registration is still open for SQL Saturday #35 in Dallas. This event will be held...
2010-03-16
552 reads
SQL Server 2008 SP1 CU7 is Released
Microsoft has released SQL Server 2008 SP1 Cumulative Update 7 (CU7). It is Build 2766. There are 31 fixes listed,...
2010-03-16
1,529 reads
Start Planning to Attend devLINK 2010
devLink 2010 will be held in Nashville, TN August 5-7 on Lipscomb University. This three day, 140+ session event costs...
2010-03-16
501 reads
Tracking data about your instances
I saw a post recently asking how to build a daily report for each instance that tracks the metrics deemed...
2010-03-16
725 reads
User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still
prompted to login....
2010-03-16
1,907 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers