Forum Replies Created
Viewing 15 posts - 10,801 through 10,815 (of 22,219 total)
-
RE: Transaction log backups ran during a full backup.
But if you're unsure, you can check the header information on the full backup and the log backup and compare the begin and end log sequence numbers (LSN). These will...
"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: Datatype stored
You can also take a look at the free Red Gate utility SQL Search[/url]. It'll hit all the databases at the same 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: DevConnections / SQL Server Connection event worth the time?
jasona.work (6/7/2012)
Thanks for the information Steve!If / when I go to the SQL in the City, it'll only be the second such event I've been too. I do (when...
"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: Licensing for Newbies
anthony.green (6/7/2012)
GSquared (6/7/2012)
anthony.green (6/7/2012)
GSquared (6/7/2012)
Again, this is just my take on the whole mess:You might be better off on a per-processor license. 2012, if I understand the licensing correctly,...
"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: Some one devloper update a column in a table, how to I find out who updated?
There's nothing in SQL Server that tracks who is making changes automatically. You have to set something up ahead of time. There are lots of ways to do that, so...
"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: Licensing for Newbies
I trust these guys, but you know what, don't listen to them. If you want answers on licensing, go to Microsoft. That's the single best source of information and 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: Your development/workstation laptop
My boss is constantly at me to switch over to Mac. Resisted so far. That's all I can tell you.
As to the rest, get lots of memory & fast...
"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 Server 2005--Running reindex every 2 days for performance reasons, Tuning advisor constantly asking me to add stats on same query
Not parsing the entire query, but several issues immediately jump out at me. First, you're not using ANSI standard JOIN syntax:
...FROM TableA AS aJOIN TableB AS b
ON a.ID = b.ID...
But...
"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: Execution context and Procedure Cache
The compile parameters are stored with the plan because they help show how the plan was created. You also get the ANSI settings stored with the plan. Other than that,...
"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 to find Top 10 Adhoc Queries in SQL Server
Assuming you're going to use sys.dm_exec_query_stats and then sort by CPU, I/O or some combination, then you can combine that DMO with sys.dm_exec_query_plan and look for queries that do not...
"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 - MOST COSTLY UNUSED INDEXES
If an index isn't being used, you should see a lack of scans & seeks in the index usage stats DMO. So you want to limit that sub-select to those...
"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 Slow after use UPDATE STATISTICS ..Why??
Mathew M.Varghese (6/5/2012)
Hi,I tryed to save as "execution plan", but it is not working in sql server 2000 version.
Regards
mathew
Oh. You're posting in the SQL Server 2008 forum, so answers might...
"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 Server 2012 Future...
I wouldn't say that SQL Server 2012 introduces anything like a new job role or new job opportunities. It expands on existing jobs and provides a few new ways 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: Does studying a Masters give you an edge in the employment stakes?
michaeljharper (6/4/2012)
GilaMonster (6/4/2012)
One thing that was part of my introductory course for my M.Sc was 'why are you doing this?' and it made it very clear that if you're just..."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 Slow after use UPDATE STATISTICS ..Why??
Mathew M.Varghese (6/4/2012)
Dearplease see the following picture, execution plan ..I am not sure, how to upload full execution plan to this forum.
Right click the plan, choose "Save As" and...
"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 - 10,801 through 10,815 (of 22,219 total)