Viewing 15 posts - 21,361 through 21,375 (of 22,224 total)
I found a blog entry over at MSDN that talks about this:
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
If you scroll down to Message #10:
Reason:
1) There are spaces after Instance name in 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
January 3, 2008 at 10:44 am
I think you have something else going on. The delays are not normal.
"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
January 3, 2008 at 10:41 am
Well it's about time.
Congratulations Steve! You earned it.
"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
January 3, 2008 at 5:51 am
Hey Jeff,
Do you have that response in a script so you can just point & click? If so, can you share the script?
"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
January 3, 2008 at 5:50 am
Hi Sandy,
When you run backups, don't use drive paths like this:
BACKUP DATABASE x TO DISK = 'C:\x.bak'
Because it will place them on the relative drive for that server. Instead,...
"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
January 3, 2008 at 5:47 am
Not knowing your friend, the company, or the interview, it'd be impossible to say why. Usually, it's because the people doing the interview thought that someone else was more qualified...
"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 31, 2007 at 6:52 am
Well, if you're lazy you can even get around that:
INSERT INTO dbo.MyTable DEFAULT VALUES
GO 42
I suspect that's not what was meant. I'd be curious if there was a method too.
"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 21, 2007 at 9:57 am
Yep. Works. Thanks.
"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 21, 2007 at 9:27 am
Actually, no, I hadn't thought of that, but since our internally developed applications are never allowed to work under a security model that would provide them with DDL, it's not...
"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 21, 2007 at 8:58 am
The fact that copying everything to a new database resulted in a working query strongly points out that something on the old database was different.
"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 21, 2007 at 8:55 am
Yeah, that's part of our best practices check list too.
"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 21, 2007 at 8:13 am
The only suggestion I can make is to assume that every problem has a set based solution up front. Then work on finding it. RBAR becomes a crutch. You just...
"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 21, 2007 at 6:57 am
Seriously, why would physical column order matter? You can always get the columns out in any order that you want through views, procedures and functions.
"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 21, 2007 at 6:49 am
My own experience and what I've been able to find, there isn't any way to directly access the reports themselves. They're not stored as .rdl files, which is what you'd...
"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 21, 2007 at 6:47 am
It's brain candy, but tasty, John Birmingham's Final Impact. It's the third book in a trilogy (I truly hate that phrase, but they must be some kind of marketing thing,...
"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 21, 2007 at 5:44 am
Viewing 15 posts - 21,361 through 21,375 (of 22,224 total)