Viewing 15 posts - 16,861 through 16,875 (of 22,219 total)
Two instances on a machine do have two different ports. They can be dynamically assigned. You say you have TCPIP enabled. Do you have the SQL Server Browser service running?...
"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
July 29, 2009 at 6:28 am
john.arnott (7/28/2009)
Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?
Just be careful of starting an internecine battle. There are more of we developers...
"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
July 28, 2009 at 12:46 pm
NULL values are not your friend when it comes to indexes. You will get a scan. Even forcing the use of the index through the hint will result in 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
July 28, 2009 at 10:21 am
Luke L (7/28/2009)
Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?
And of course a ppt preso won't quite cut it. Perhaps use Grant...
"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
July 28, 2009 at 10:16 am
Jack Corbett (7/28/2009)
Do you guys meet monthly?The next time I'm in New England maybe I can schedule to be your area around a meeting time.
Yep. Once a month. We'd love...
"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
July 28, 2009 at 10:15 am
I just validated it, you can get the start time for a statement within a batch by querying sys.dm_exec_sessions. I posted a blog entry on it here[/url].
"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
July 28, 2009 at 9:27 am
Jeff Moden (7/28/2009)
Grant Fritchey (7/28/2009)
Jeff Moden (7/27/2009)
Grant Fritchey (7/27/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
July 28, 2009 at 9:24 am
There is no process for creating system catalog views. They are part of the normal running of the system and will be there after a successful install.
Are you sure...
"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
July 28, 2009 at 5:45 am
there is just no way to be sure. You have to know all the processes that access the system inside & out. For example, even if you monitor the system...
"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
July 28, 2009 at 5:42 am
Jeff Moden (7/27/2009)
Grant Fritchey (7/27/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
July 28, 2009 at 5:14 am
Lynn Pettis (7/27/2009)
Kassondra is now on her way to Fort Jackson in South Carolina to start her...
"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
July 28, 2009 at 5:12 am
I have yet to see someone eliminate code duplication within a database. It's just too easy to start doing... whatever. Generally a good naming convention will tend to inform 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
July 27, 2009 at 12:58 pm
My younger sister had plates that read IODADDY or something like that. I always read them as 'I/O Daddy' like some sort of nifty geek hipster, not 'I owe daddy'...
"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
July 27, 2009 at 11:52 am
Huge topic. You might want to start off defining your role. Take a look at Craig Mullins book called "Database Administration." It's system agnostic and very useful.
"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
July 27, 2009 at 11:26 am
If you mean that you intend to use functions instead of referring to the tables or views, excercise a great deal of caution here. An in-line table valued function can...
"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
July 27, 2009 at 11:20 am
Viewing 15 posts - 16,861 through 16,875 (of 22,219 total)