Viewing 15 posts - 7,621 through 7,635 (of 22,213 total)
William J. Fellows (7/31/2014)
To qualify my statement, Steve stares at my legs a lot. 😛
Me too! Va-va-va-voom!
July 31, 2014 at 1:03 pm
Another vote for the side-by-side upgrade. In place upgrades burn sometimes. I'm just not a fan.
And yes, your boss is wrong. That's not the right way to go about it...
July 31, 2014 at 12:14 pm
Sarah Wagner (7/31/2014)
July 31, 2014 at 8:57 am
New Born DBA (7/31/2014)
Grant Fritchey (7/31/2014)
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.I live in Chicago, IL
So, you're employer...
July 31, 2014 at 8:56 am
A CTE is just a query. All by itself, it's not good, it's not bad. It's just a query. What will hurt performance is what you're querying, how you're querying...
July 31, 2014 at 7:36 am
The DMV is going to readout what it gets from the performance counters, yes. Are there changes in behavior between 2008 and 2012? Yes. Will those changes possibly be evidenced...
July 31, 2014 at 7:01 am
Serializable has to take exclusive locks of everything it touches, including reads. So, any other process that is reading anything that the process running in Serializable needs, is going to...
July 31, 2014 at 6:58 am
patrickmcginnis59 10839 (7/30/2014)
Grant Fritchey (7/30/2014)
patrickmcginnis59 10839 (7/30/2014)
Then whats the problem with defending SO?I wasn't aware there was one. Someone offered an opinion. You disagreed. Others disagreed with you. Etc.
I...
July 31, 2014 at 6:56 am
Lynn Pettis (7/31/2014)
Lynn Pettis (7/31/2014)
SQLRNNR (7/30/2014)
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
It could work - depending on what the data is in that...
July 31, 2014 at 6:48 am
Zubius (7/30/2014)
“You can let your DBA know that our databases must be set to “Simple” logging and they...
July 31, 2014 at 4:38 am
Statistics changes will lead to a recompilation, not a compilation, as plans in cache are invalidated and they are recompiled due to the statistics updates.
I haven't compared just compile statistics...
July 31, 2014 at 4:36 am
Each of those procedures will commit, individually. Even though one of them doesn't have the COMMIT statement. SQL Server runs in autocommit transaction mode by default.
July 31, 2014 at 4:32 am
cdm33.com (7/30/2014)
This code has hundreds of lines to it. I've got no clue what it does. I'm not going to put something like this on a production server...
July 31, 2014 at 4:28 am
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.
July 31, 2014 at 4:24 am
I'm putting on a full day of query tuning at Connections in September and at the PASS Summit in November. The advantage of going to either of these is that...
July 31, 2014 at 4:23 am
Viewing 15 posts - 7,621 through 7,635 (of 22,213 total)