Today we have a guest editorial as Steve is on vacation.
Like many others, I read the page on MSDN Maximum Capacity Specifications for SQL Server with a low whistle of amazement. 524,272 terabytes? 253 foreign key references per table? 2,100 parameters for a stored procedure? Could anyone be getting anywhere near those limits?
I get to hear about, and sometimes come across, some enormous SQL Server databases. I’ve worked on, and occasionally designed, a few myself. It has left me with a deep respect for the way that SQL Server copes, and the amount of work that is required to create and maintain a database system that can handle large amounts of data. I hope, therefore I can be forgiven a smile when a hopeful startup announces a new database system to rival the behemoths of the database industry, or when someone refers to a database as ‘Big Data’ when it would even fit in a spreadsheet.
The databases I’ve dealt with are dwarfed by the titans that I’ve heard about through talking to colleagues at PASS or reading about in forums. Sometimes, I come across them by accident. I once wrote a routine that automatically converted the deprecated Rules and Defaults into constraints. I tested it out on what I thought were some fairly large databases. I then got a complaint from someone who used it that the routine was much too slow. I blinked in wonderment. I hadn’t even bothered to optimise it since it ran in a twinkling of an eye. I should have guessed that it wouldn’t scale well when faced with a database with 60,000 tables. Fortunately, he fixed it to work fine with that sort of size of database. I couldn’t help wondering how SSMS would cope with a database that size!
For various reasons, we don’t get to hear about all those huge SQL Server databases that work well. Which industry has the biggest systems, in terms of sheer volume, or in processing power? What are the types of database that scale easily, and what special techniques are required? I’d be fascinated to hear from people running really big databases successfully with SQL Server.
Dattatrey Sindol shares his tips and tricks on SQL Server Reporting Services Report Manager. He provides guidance on Customizing Report Manager Header/Title, Uploading Custom File Types to Report Manager, and Enable My Reports Feature.
I was presenting a session on how to read execution plans when I received a question: Do you have a... More »
Question of the Day
Today's Question (by sqlnaive):
What will be the output of the last Select statement:
CREATE TABLE dbo.T_TEST(Col1 DECIMAL(20,2), Col2 INT)
INSERT INTO dbo.T_TEST SELECT 5000.50, 65
INSERT INTO dbo.T_TEST SELECT NULL, 100
INSERT INTO dbo.T_TEST SELECT 6666.25, NULL
SELECT COALESCE(Col1, Col2) AS 'FirstNotNull' FROM dbo.T_TEST
DROP TABLE dbo.T_TEST;
Note: Code is tested in SQL 2008 version.
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: Coalesce.
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Paul Cauchon):
What is returned by the select statements?
declare @word varchar(100) = 'apple'
declare @table table(id int)
set @word = 'pear'
select COUNT(*) from @table
Answer: NULL, pear, 0
Explanation: Immediately after parsing, objects are validated by the query optimizer without respect to the logical TSQL constructs in the code. After all objects are bound, the algebrized tree (with all of its objects) is used to create candidate execution plans, now considering the TSQL logic.
Adding time intervals in minutes and display as csv
- i have a table with three columns as
col1 col2 col3
11:30 13:30 15
00:10 01:40 5
the out put should be as follows
Problem in query
i have a problem regarding query,
my data is like this
123-----7/1/2013 08:00:00 PM-----I---------
123-----7/2/2013 02:00:00 AM-----O---------
I means in and O means...
how to get the desired output correctly
- i have a table emp with records as follows:
Create table testemp
insert into testemp values ('tsaliki','h1')
insert into testemp values...
How to insert in a 3 table
- I Have 3 tables....namely Bio, Sex, Status
Sex(Male or Female)
Status(Single, In Relationship or Married)
here is my question...
How can i insert in...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.