Viewing 15 posts - 8,386 through 8,400 (of 22,219 total)
This is an article[/url] that I wrote on statistics. Here's another[/url] answering a series of common problems about statistics. If you have specific issues, let us know.
"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
April 17, 2014 at 8:23 pm
You can't really do this yet because SQL Database doesn't support Windows logins, so there's no way to add it to a network. Since it only supports SQL Logins, 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
April 17, 2014 at 8:20 pm
No, a backup needs to be restored. You can only attach a database that has been detached (or at least shut down).
"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
April 17, 2014 at 8:16 pm
Does your backup use WITH INIT? It really sounds like the backup is stacking up. What is the precise command you're using to do the backup. If you're using 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
April 17, 2014 at 8:10 pm
No. But remember, it's just a guideline. You may need to adjust it up or down for your given situation. But it does give a starting point.
"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
April 14, 2014 at 4:13 am
Cars is an extra letter and I'm a completely lazy SOB. I'd rather just have Car, as long as it's clear, right. I mean, not Cr or something else stupid.
"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
April 13, 2014 at 5:41 am
The first couple of sentences in the article I linked gives you a calculation. 1gb to the OS for every 4gb of memory up to 16gb. So, if you have...
"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
April 13, 2014 at 5:37 am
souLTower (4/12/2014)
"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
April 12, 2014 at 10:11 am
I just use SQL Prompt instead of dragging and dropping. It works a lot better and includes all kinds of extra functions.
And yeah, I work for Red Gate, but I...
"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
April 12, 2014 at 6:42 am
Also take a look at Louis Davidson and Tim Ford's book on Dynamice Management Views.
"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
April 12, 2014 at 6:41 am
SQL Server will consume all the memory you allow it to have. That's how it works. You should allow it as much memory as you can on any give server...
"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
April 12, 2014 at 6:39 am
Your best bet for something like this would be to use Extended Events. You can capture execution of queries and it has very good filtering so you can just get...
"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
April 12, 2014 at 6:34 am
After you make the change that Gail suggests, here's a very large percentage of everything you need to know about In-Memory OLTP. Make sure you read through all the recommendations...
"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
April 12, 2014 at 6:32 am
And don't miss out on free opportunities in your area. SQL Saturday Chicago is happening in just a couple of weeks. SQL Saturday Madison was just a couple of weeks...
"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
April 12, 2014 at 6:29 am
Tune the query. Tune the data structure. Tune the indexes. Keep the statistics up to date. That's about all I can based on the query running slow and that's all...
"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
April 11, 2014 at 11:06 am
Viewing 15 posts - 8,386 through 8,400 (of 22,219 total)