Viewing 15 posts - 18,196 through 18,210 (of 22,226 total)
Since I'm using SQLPrompt Pro, I can force the formatting however I want. I just saw that Apress has a formatting tool that's free. It might be worth a look-see.
"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
February 26, 2009 at 1:23 pm
I can't say I'm crazy about it, but all the cool kids are doing it, so I do to.
"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
February 26, 2009 at 1:10 pm
Since there are so many hard core SF readers on here, I thought I'd pass on what I just heard. Phlip Jose Farmer has died. http://reason.com/blog/show/131886.html
I read tons and tons...
"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
February 26, 2009 at 10:47 am
You can set a database to be read_only and you can set a file group to be read_only. I don't think you do that with a table. If it's 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
February 26, 2009 at 8:55 am
Oh, you mean something that captures the execution context, that'll show the methods used to call the proc like EXEC blah, blah and include the parameter names & values?
In 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
February 26, 2009 at 8:14 am
Heck. I thought LISP was stacks of comma's. What am I thinking of then. I worked with some damned language back in '92 or '93 where the code looked like:
exec...
"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
February 26, 2009 at 6:56 am
I'm sorry, I don't understand the question.
When you create a procedure, you define parameters with a certain name and a certain data type, nullability and default values. Within the procedure...
"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
February 26, 2009 at 6:24 am
In general DBA's are considered trusted employees because they can access the data. That's one of the reasons the job pays more. If they can't trust the DBA, time to...
"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
February 26, 2009 at 6:13 am
For those that have the trees, I can't recommend an outdoor woodburning furnace enough. We've been toasty through one of the coldest winters I've ever experienced. Of course, when we...
"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
February 26, 2009 at 5:41 am
I have been working exclusively in the 2008 Management Studio for over a year now (beta's), so I don't remember 2005 real well, but 2008, the parenthesis highlighting is definitely...
"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
February 26, 2009 at 5:36 am
RBarryYoung (2/25/2009)
Jeff Moden (2/25/2009)
"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
February 26, 2009 at 5:31 am
I always suggest Itzik Ben-Gan's books, SQL Server 2008 T-SQL Fundamentals and/or Inside SQL Server 2005: T-SQL Programming.
Hey GSquared, Paul Neilsen is supposed to finish the 2008 version of 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
February 25, 2009 at 1:02 pm
Are you sure you don't have that backwards? It works in 2008 but doesn't in 2005.
That's because 2008 introduced intellisense and several other code formatting enhancements such as those little...
"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
February 25, 2009 at 12:59 pm
Bob Hovious (2/25/2009)
It's not barrier to entry. Nobody has to take a test on the material. It's just something that first time...
"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
February 25, 2009 at 11:50 am
Another vote for Red Gate's SQL Prompt. It's better than the intellisense in 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
February 25, 2009 at 9:37 am
Viewing 15 posts - 18,196 through 18,210 (of 22,226 total)