Viewing 15 posts - 9,781 through 9,795 (of 22,226 total)
I would take any and all licensing questions direct to Microsoft. Never trust any type of licensing answer you get from some nameless, faceless individual on the internet.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 11:40 am
A geography type consists of both latitude and longitude. You're trying to store them seperately and you can't do that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 11:38 am
Getting the wait statistics gives you some idea of what is causing the server to run slow, on average. To understand what is causing the server to run slow over...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 8:44 am
I wouldn't say there are new threats beyond what we've outlined here. SQL Server 2000 is good, as far as it goes. It's just grossly inadequate on a million levels,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 7:24 am
To know if it's the app or the database, you need to capture performance metrics from the database as it's running. There's a lot to that. I wrote about a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 6:36 am
chris.dunbar (5/29/2013)
Having looked round this site (mostly) and done a bit extra reading, there are many functions that I don't think we utilise. A...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 6:32 am
The DTA works off of statistics and the indexes you have in order to make calculations to arrive at possible improvements. But, understand, statistics are simply a mathematical sampling of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 5:07 am
Brandie Tarvin (5/29/2013)
Grant Fritchey (5/29/2013)
Brandie Tarvin (5/29/2013)
How much RAM would you recommend?All of it.
So I should add a million TB to my laptop? @=)
If you can, yes.
I've got 32gb on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 5:02 am
One suggestion, get a consultant who really knows SQL Server to do the final technical interview of anyone you think might be a good fit. There are published interview questions...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 5:01 am
Brandie Tarvin (5/29/2013)
How much RAM would you recommend?
All of it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 4:42 am
On a side note, don't rely too much on certifications. Except for the advanced certification, Microsoft Certified Master (MCM), most of the certifications are extremely straight-forward tests that people can...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 4:41 am
It looks like the basic restore operation is set up fine. It's mainly a question of getting the connections clear before you restrict access to the database. You're going to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 4:39 am
SQL Server Management Studio (SSMS) is the front end for managing SQL Server. It provides two things, a graphical user interface for managing your SQL Server instances, your databases, the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 29, 2013 at 4:31 am
SQLBill (5/28/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2013 at 9:13 pm
Well, backups, obviously. The issue for me would be, are we talking about functionality that belongs inside the same database or not? For example, do we need referential integrity. You...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2013 at 9:08 pm
Viewing 15 posts - 9,781 through 9,795 (of 22,226 total)