Viewing 15 posts - 10,216 through 10,230 (of 22,213 total)
I've started working with Hadoop. I'm going to keep going with that and expand into more Azure SQL Databases.
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.
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...
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...
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...
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?
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....
December 9, 2012 at 4:38 am
Everything is getting fixed. Sorry for any issues.
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...
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...
December 5, 2012 at 6:49 am
david.williams 50026 (12/5/2012)
December 5, 2012 at 6:23 am
Lars-640955 (12/4/2012)
"Free eBook: SQL Server Execution Plans, Second Edition"
And you can quote me on that one!
My time is my...
December 5, 2012 at 6:07 am
Patrick Kansa (@pkansa) (12/4/2012)
No worries, here,...
December 5, 2012 at 6:06 am
It's the book on query tuning. I'd suggest you get the 2008 version of the book. Most of what's in it will be applicable to 2000, unlike the 2012 book...
December 4, 2012 at 11:08 am
kent.kester (12/4/2012)
To be honest, I had to read it a couple times and go through what I thought I knew before saying anything. 😉
Ha! I passed it along to...
December 4, 2012 at 8:06 am
Viewing 15 posts - 10,216 through 10,230 (of 22,213 total)