Forum Replies Created
Viewing 15 posts - 15,781 through 15,795 (of 22,232 total)
-
RE: How many of you have done Certification for SQL Server?
Roy Ernest (3/5/2010)
The top level Grant guy we are talking about is a scary one... 😛Yes true regarding the knowledge base. I know nothing about BI, I have done only...
"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: How many of you have done Certification for SQL Server?
I don't know who this top-level Grant guy you're talking about is.
I recently interviewed at a company where it was made pretty clear, just how little I know. You're only...
"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: Dropping constraints and re-create the same
If you're trying to simply identify the objects, sure you can use straight TSQL, but if you're trying to generate scripts, you really need to look at some method of...
"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?
Jack Corbett (3/5/2010)
For those not on Twitter, I passed the 70-432 Implementing and Maintaining SQL Server 2008 exam yesterday. Easier than I thought it would be. If..."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: How many of you have done Certification for SQL Server?
I think this really comes to down to personal preference and/or experience. Here's my 1.5 cents:
I am not certified. Based on my current job, salary, experience level, and experience interviewing...
"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: Blocking on insert
It doesn't sound too mysterious. You say you get bursts of inserts over time, and these bursts can cause page splits or whatever within the index and while things are...
"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 performance down
Are the databases identical? If not, it's down to the code & structure of the database in question. I'd try setting up a trace and capturing queries for a time...
"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: Blocking on insert
Without seeing the structure, it's hard to say, but at a guess, it's the index reordering itself as the inserts come in.
Query the sys.dm_exec_query_stats and sys.dm_exec_query_plan to get the aggregated...
"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: how to Improve query performance?
What does the execution plan look like? Where do you have indexes on the table? How selective is the data you're using for your filtering? Answering these questions will tell...
"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: Query Execution Time Variance
Without an index, you're seeing table scans. If you had an index, I'm fairly sure the '< 3' operation would work well (depending on the distribution of the data). It's...
"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: Dropping constraints and re-create the same
Personally, I've put PowerShell to work on this problem. Generating scripts from within TSQL can be a bit problematic. Using SMO, which is how the Management Studio works, is much...
"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: Overusing Identities
David Portas (3/2/2010)
RalphWilson (3/2/2010)
An email address is a perfectly reasonable unique identifier provided you have the ability to change it.David,
You have got to be kindding. Not everyone has an...
"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?
CirquedeSQLeil (3/1/2010)
Feet were created to kick balls.No disagreement 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: Overusing Identities
I'm going to go with Gail & David, there's nothing all that wrong with using Identities as your PK as long as you've also defined the natural key through a...
"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: Method to Dump out SQL Server Instance Configuration, Version/SP, etc.
It's available as a download from Microsoft. Try 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
Viewing 15 posts - 15,781 through 15,795 (of 22,232 total)