Viewing 15 posts - 10,231 through 10,245 (of 22,232 total)
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
david.williams 50026 (12/5/2012)
grrr I am using the following syntax:BEGIN TRANSACTION
UPDATE dbo.attcat
SET Val = 50
WHERE ID = i_att_type;
--ROLLBACK TRANS
But keep getting:
Msg 207, Level 16, State 1, Line 2
Invalid column name 'ID'.
Is...
"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 6:49 am
david.williams 50026 (12/5/2012)
"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 6:23 am
Viewing 15 posts - 10,231 through 10,245 (of 22,232 total)