Viewing 15 posts - 18,976 through 18,990 (of 22,226 total)
Another reason I dislike the things.
Single line table valued UDF's do resolve out more like views and are part of the execution plan, for what it's worth.
"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, 2008 at 7:17 am
Chris Morris (12/19/2008)
Grant Fritchey (12/19/2008)
"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, 2008 at 6:52 am
I honestly couldn't tell you. I've installed both to my laptop, also running XP. I've installed 2000, 2005 and 2008 to my desktop with no issues, problems, erorrs, or extra...
"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, 2008 at 6:49 am
jcrawf02 (12/19/2008)
Chris Morris (12/19/2008)
Someone said beer I swear...Nicest beer this week was Blue Moon wheat beer from Denver, CO, purchased from Sainsbury's, Reading, UK.
My sister-in-law is crazy about that stuff....
"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, 2008 at 6:39 am
Jason Miller (12/19/2008)
The Holodeck?...
"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, 2008 at 6:33 am
Multi-line table valued functions are notorious performance pigs. They have not statistics so anything more than a few rows will perform pretty poorly. For more information, check out Gail's blog:...
"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, 2008 at 6:25 am
If you can't partition, you could try simulating it. Use a view, that you'll need to rebuild regularly, and split the data up into multiple physical tables, seperated by day,...
"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, 2008 at 6:13 am
Or at least post the execution plan.
"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, 2008 at 6:10 am
Assuming you give 2008 a different instance name, no you don't need to uninstall 2005. They run side-by-side just fine. Not that I'd run them side-by-side on a production server.
"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, 2008 at 6:08 am
Do you have traceflag 1222 and/or 1204 enabled? That will output the deadlock graph to the error log when the deadlocks occur. It will specify exactly where the deadlock 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 19, 2008 at 6:07 am
I think the one thing you're missing is, by and large, you don't need to worry about lock management. SQL Server manages locks for you. You do need to understand...
"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, 2008 at 6:03 am
It really depends on what you mean by "auto"
There is the startup proc, and there can be only one. You can also set up triggers to respond to ddl or...
"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, 2008 at 5:58 am
Nuts. I was going to put Collosus up. The Forbin Project.
It's also a series of books; Collosus, Fall of Collosus, Collosus and the Crab.
I suspect they're VERY dated now.
Oh, hey,...
"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, 2008 at 5:33 am
Now see, we're still stuck because I thought that translated out as "Time for a beer."
"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 18, 2008 at 7:59 pm
Yeah, I'm not so sure about that one. I was helping someone from Spain and the Spanish column names made things more than a bit confusing.
"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 18, 2008 at 1:21 pm
Viewing 15 posts - 18,976 through 18,990 (of 22,226 total)