Viewing 15 posts - 18,151 through 18,165 (of 22,226 total)
Something. That isn't closing it's connections. Could be SQL, could be something else. Probably something else.
"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
March 3, 2009 at 9:47 am
That sounds like some app isn't closing it's connections. Lots of open connections will certainly chew up memory eventually.
"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
March 3, 2009 at 9:31 am
It can be yes. If you look through the white paper though they're using DMV (dynamic management views) which give you a lot more detail that you'll get through 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
March 3, 2009 at 9:10 am
Stamey (3/3/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
March 3, 2009 at 9:04 am
Hmmm... Well, have you tried looking at the wait states and queues? That's where I'd go next. See what everything is waiting on. Here's an excellent article on it: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc
"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
March 3, 2009 at 8:41 am
One issue I've seen repeatedly with linked servers is running the query such that the filters are processed on the SQL SErver side. This requires that a SELECT * be...
"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
March 3, 2009 at 8:30 am
Stephanie Smith (3/3/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
March 3, 2009 at 8:19 am
I don't understand the question. Do you mean generating individual TSQL scripts through the GUI?
2005 & 2008 are pretty much the same. Where are you hitting issues?
"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
March 3, 2009 at 6:32 am
Backup and restore works just fine. You can also detach, copy and attach as an upgrade process. Whichever you end up doing, just make sure you run it through 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
March 3, 2009 at 6:24 am
GilaMonster (3/3/2009)
Grant Fritchey (3/3/2009)
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
Not with it, but Management Studio Express...
"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
March 3, 2009 at 6:14 am
I would say both approaches are valid. You need to do what your business defines. You're already on the right track, make sure you update the statistics and defrag 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
March 3, 2009 at 6:10 am
You need to be sure that your string data is defined as unicode so that you can define the character set as well as the values. This means NVARCHAR 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
March 3, 2009 at 6:06 am
There are no issues with SCOPE_IDENTITY that I'm aware of.
One way you can try to debug this is to use the OUTPUT clause. I use it instead of SCOPE_IDENTITY because...
"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
March 3, 2009 at 6:04 am
Well, what you've really defined is a DISTINCT on both fields. You're getting all values that match a list for both criteria. It's not really a unique listing 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
March 3, 2009 at 6:02 am
You really need to show what's been done so far, even if you haven't done much.
What language are you using for the scripting? Are you doing everything through T-SQL 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
March 3, 2009 at 5:55 am
Viewing 15 posts - 18,151 through 18,165 (of 22,226 total)