Viewing 15 posts - 11,596 through 11,610 (of 22,224 total)
matt.newman (11/30/2011)
"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
November 30, 2011 at 12:16 pm
Having done the method of trying to maintain "clean" database copies that are then moved around for restore purposes and having had four (4) times the amount of disk storage...
"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
November 30, 2011 at 11:04 am
Same goes with plugging in the Cumulative Updates after you get to the latest service pack. If you don't know what's causing your slow down, you might see a fix...
"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
November 30, 2011 at 10:55 am
Any increase in performance from one SP to the next is most likely to be extremely marginal. If you're hitting performance issues, you need to do the hard work 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
November 30, 2011 at 7:27 am
I also recommend starting with Gail Shaw's articles linked above. It's an excellent place to get started. I'd also suggest you pick up a copy of my book on exactly...
"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
November 30, 2011 at 7:25 am
The one wrinkle that I might add to it would be to set up these servers as a virtual and then copy that out to the developers workstations, but I...
"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
November 30, 2011 at 4:49 am
Tom Brown (11/29/2011)
What is the error when you try create table in ssms?
That's a permissions issue. Were you logged in under a different account? Did your access get changed?...
"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
November 29, 2011 at 7:08 am
I would generally go with JOIN and CROSS APPLY to solve these types of issues. Assuming you can do a single statement table valued function, that might work too. For...
"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
November 29, 2011 at 7:06 am
Hmmm... Not sure then. Is FILESTREAM still configured to that drive? It might be interfering with using it for data files. Can you restore the database using WITH MOVE 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
November 29, 2011 at 5:53 am
It could be a security issue. Does the account that your SQL Server instance is running under have access to that drive? You might, but does SQL Server?
"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
November 29, 2011 at 5:43 am
Just run checkpoint. You're telling sQL Server to flush to disk, which means it'll clear committed transactions from the log. But, since your logs are currently full, most 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
November 29, 2011 at 5:21 am
engrshafiq4 (11/29/2011)
YOu right clicked on database ....i just want to export one table and then import that table in another db....i can view like ur attached
Exactly.
Right click on the database...
"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
November 29, 2011 at 4:59 am
Sounds like you're in FULL recovery but you haven't been running log backups[/url]. There's no way to bring in a portable drive or something to set up for a backup?...
"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
November 29, 2011 at 4:49 am
If you want to find out what is currently running for a long time use sys.dm_exec_requests. You can combine that with other DMOs such as sys.dm_exec_sql_text and sys.dm_exec_query_plan 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
November 29, 2011 at 4:43 am
You could create a linked server on production to your local machine. Then you can use SELECT INTO syntax to recreate the table.
Are you using SQL Server Management STudio? 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
November 29, 2011 at 4:39 am
Viewing 15 posts - 11,596 through 11,610 (of 22,224 total)