Forum Replies Created
Viewing 15 posts - 8,866 through 8,880 (of 22,224 total)
-
RE: TempDB Growing
Yes, you can break down the process, and probably should. But telling you how based on nothing other than "the process is big" is pretty hard.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL clustering In Azure?
You sure can. Microsoft has good documentation on it here and here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Hi any one help me
SQL Injection
It's not a good thing. You are absolutely making it possible with that code. Please stop and tell all your friends.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Backup strategy
I'd say the current setup is OK. If anything, I wouldn't go with lots of full backups because you do pay for that with load on the system. Plus, as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Log Files Growing, even in Simple Mode
No way in the world, at all, to avoid the log, so best practice is to find ways to deal with it. No other choice there. If you don't need...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Performance Tuning - Proof in the pudding
If I don't have the before and after I don't know if I tuned it, let alone telling my boss that I just shaved X amount of time or resources...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Dumb interview answers
jshahan (2/20/2014)
We developed a test that required applicants to write queries against our proprietary database that would answer a list of specific questions we provided along with which tables to..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Understanding Graphical Execution Plans - Part 1: Explaining the Plan
rchantler (2/18/2014)
"If an object in the query does not exist, the validation fails and no estimated plan is created"Is something executed in this case, i.e. is there an actual execution...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Downstream query recompile when index is drop and re-created.
Happy to help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Downstream query recompile when index is drop and re-created.
Test it:
CREATE TABLE dbo.LetsRecompile(
ID INT IDENTITY(1, 1),
MyVal VARCHAR(50)
);
GO
CREATE INDEX WhatHappens ON dbo.LetsRecompile...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Database security
Sure. Go read this book by Denny Cherry.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
wolfkillj (2/19/2014)
Fixed that for you.SQLRNNR (2/19/2014)
Yay - I'mfinallyinsane!!! :hehe::w00t:I was wondering who was going to break it to him.
Congrats Jason.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: mdf / ndf backup confusion
You can always look at the backup files themselves to understand the structure of the database that was backed up. I have an article on that on Simple-Talk[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
SQLRNNR (2/19/2014)
Grant Fritchey (2/19/2014)
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason, not sure about...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 8,866 through 8,880 (of 22,224 total)