Viewing 15 posts - 16,216 through 16,230 (of 22,221 total)
You can connect directly to TFS from SQL Server Management Studio. It will allow you to create a solution and add scripts to it, check them in & out, etc....
"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
October 30, 2009 at 6:31 am
I hate to say it, but I think it's you. I very seldom have two instances of SSMS open and then it's usually one logged into the production servers and...
"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
October 30, 2009 at 6:22 am
Small scripts that I use all the time go into Red Gate SQL Prompt. Bigger scripts go out to a sharepoint site. All our projects are built from source control,...
"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
October 30, 2009 at 6:15 am
GilaMonster (10/29/2009)
CirquedeSQLeil (10/29/2009)
How do you find the time? School, articles, SSC, writing books, work...
School?
It's 11pm and I'm just starting on a report that'll likely take 2-3 hours. Answer your...
"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
October 29, 2009 at 3:15 pm
Magy (10/29/2009)
I don't think I would be able to use a .NET session or state table, because I need it to be in SQL Server.
Reason being,...
"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
October 29, 2009 at 7:29 am
meichner (10/29/2009)
Grant Fritchey (10/29/2009)
The problem is, it's really easy to get a circular reference. All you need 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
October 29, 2009 at 6:56 am
I'm pretty sure that one can be done on the fly and doesn't require a restart (but I could be wrong). I'd have to look it up to be 100%.
"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
October 29, 2009 at 5:42 am
ERStudio is probably one of the highest quality modeling tools you're going to run into. Almost anything else is a step down. It might not function like Word or Excel,...
"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
October 29, 2009 at 5:15 am
I agree. Temporary tables are meant for temporary storage within a single connection's life on the server, not for the entire time an application is being used. You need a...
"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
October 29, 2009 at 5:09 am
Hey Flo,
I think you might want to try Wesley's idea. Think about it like tempdb, if it's shrinking and growing depending on load within the range you specified, it might...
"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
October 29, 2009 at 5:04 am
The Red Gate database documentation tool, SQL Doc, will do it I think.
The problem is, it's really easy to get a circular reference. All you need is a set of...
"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
October 29, 2009 at 4:55 am
Bob Hovious 24601 (10/28/2009)
Come to think of it, I need to get...
"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
October 29, 2009 at 4:33 am
CirquedeSQLeil (10/28/2009)
No Pass this year (much like Jeff). However I was able to swing SQL Connections in Vegas :w00t:
Look me up in Vegas. I'm presenting there as well.
"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
October 28, 2009 at 4:52 pm
GilaMonster (10/28/2009)
CirquedeSQLeil (10/28/2009)
Anybody know anything more about it, opinions or otherwise?
I know a great deal about it. Would you be interested in my highly biased opinion? (I'm one 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
October 28, 2009 at 4:23 pm
Roy Ernest (10/28/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
October 28, 2009 at 4:21 pm
Viewing 15 posts - 16,216 through 16,230 (of 22,221 total)