Viewing 15 posts - 10,216 through 10,230 (of 22,219 total)
Just so you know, many of the Red Gate softwares are licensed per user. This means, as long as it is you using the software, you can install it 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
January 3, 2013 at 4:02 am
Maintenance plans and SQL Agent jobs are stored within the system databases on the your server. So, with a failover cluster where the databases are the shared item between 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
January 3, 2013 at 3:58 am
That is not something I've run into during any of the upgrades I've done. Have you looked to see which specific jobs are missing? Is there anything unique about them?
"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
January 3, 2013 at 3:56 am
Happy New Year Threadizens.
Be safe out there.
"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
January 2, 2013 at 6:57 am
You'll have to CAST one of the data types to one or the other in order to combine them.
"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
January 2, 2013 at 6:39 am
Determining the "best" tool really is a part of determining what your needs are. The different tools out there are all pretty good, but they do things differently and delivery...
"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
January 2, 2013 at 4:53 am
I've started working with Hadoop. I'm going to keep going with that and expand into more Azure SQL Databases.
"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
December 19, 2012 at 12:48 pm
Generally, for accurate counts, I'd run a COUNT(*) query. Assuming good indexes on the table, you're guaranteed a quick and accurate value.
"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
December 19, 2012 at 12:47 pm
Your safest bet there is to use the UTC dates. If you do anything else, you're likely to run into a problem. While they will have a bias towards keeping...
"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
December 19, 2012 at 12:44 pm
pdanes (12/19/2012)
Grant Fritchey (12/19/2012)
Whatever your data structures are, so should your parameters be, both in data type and length. What do the structures look like?
Well, the data structure may be...
"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
December 19, 2012 at 12:41 pm
Yep, Gus has it nailed. Management Studio is making that conversion. Plus, in the engine, SQL Server itself is using a binary to deal with execution plans, not XML, so...
"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
December 19, 2012 at 12:13 pm
Whatever your data structures are, so should your parameters be, both in data type and length. What do the structures look like?
"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
December 19, 2012 at 12:10 pm
CGSJohnson (11/21/2012)
Hi, Grant. Given it has been a while since your last post on this topic, and with the introduction of new releases of E/F, any new opinion(s)?Thanks...Chris
Nope. Sorry....
"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
December 9, 2012 at 4:38 am
Everything is getting fixed. Sorry for any issues.
"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
December 7, 2012 at 3:21 am
david.williams 50026 (12/5/2012)
No but i_att_type IS a column, how do I tell it to use that? I thought WHERE ID = i_att_type; was telling it WHERE to update?
No, 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
December 5, 2012 at 7:00 am
Viewing 15 posts - 10,216 through 10,230 (of 22,219 total)