We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in them already. We need to use these tables consistently and our performance involving reporting is struggling. Do you have any tips to help improve it?
2008-10-22
4,961 reads
Diving deeper into Reporting Services with this SQL School video, MVP Brian Knight shows how to create a report with a multi-select parameter, allowing the user to select multiple items for inclusion in the report.
2008-10-21
5,944 reads
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
2008-10-21
62 reads
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
2008-10-21
73 reads
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
2008-10-21
63 reads
This installment of our series focuses on establishing, conducting, and terminating a sample Service Broker dialog in a distributed environment, leveraging previously established routes and dialog-level permission.
2008-10-21
1,729 reads
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?
2008-10-21
5,907 reads
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
71 reads
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
75 reads
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
62 reads
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers