Watch The Latest Weekly SQL Server Show
> Watch SelectViews – now with the segment selector in Beta, allowing you to jump around the show.
Featured Article(s)
Tips for using SQL Server 2005 Merge Replication (Part 1)
Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication.
It’s Like A SQL Server Private Investigator…
When it comes to finding out what’s up with SQL Server, you need to know the whole picture about not only SQL Server performance, but other things that impact overall query performance. This is where Ignite comes in from Confio. With Confio Ignite, you can see exactly what’s impacting your SQL Server’s performance, how to minimize things that are delaying response times and so much more. Find out why HP, Metlife and many, many others are relying on Confio Ignite to really dig into what’s happening with their SQL Servers and how to fine-tune them. Get more information here, and even a free trial that you can exercise on your own system.
Webcast Today:
SQL Server Optimization and Data Protection with Intelligent ISCSI SANs
More and more companies are deploying storage area networks or SANs as storage needs continue to proliferate. SANs deliver many unique capabilities that improve data protection, storage performance and scaling, and reduction in storage management time. Intelligent iSCSI SANs offer an affordable, enterprise-class choice in SAN technologies. We will review best practices in deploying SQL Server in an intelligent iSCSI SAN, and the resulting dramatic improvements in deploying, optimizing, backing up, and recovering SQL.
> Register Now
> 8/29/2007 at 12:00pm Noon Pacific
Help for the Reporting Services Question
Wanted to pass along the top suggestions for handling the reporting services call for help from a reader. The goal was to return 15, and exactly 15 rows for the report, padding if necessary, so the report mimic’d a form.
Patrick: "Couldn’t the stored procedure that yields the data generate dummy players with blank names? It isn’t pure SQL, granted…
Current SQL: Select name, team from players
New pseudo-SQL:
Insert into @teamlist (team)
Select distinct team from players
Insert into @newplayers (name, team)
Select name, team from players
While exists (select top 1 @current_team = team from @teamlist) begin
While (select count(*) from players where team = @current_team) < 15
Insert into @newplayers (name, team) values (‘’, @current_team)
Delete from @teamlist where team = @current_team
end"
Featured White Paper(s)
Meeting Sarbanes-Oxley Requirements with DB Audit
… (read more)
Improving .NET Application Performance and Reliability with Managed Database Connectivity
Your choices about data access can make the difference between project success and project failure. Read this whitepaper and… (read more)
The Payment Card Industry Compliance – Securing both Merchant and Customer data
This white paper introduces the Payment Card Industry Compliance standard, and the security threats which brought about the n… (read more)