Viewing 15 posts - 5,101 through 5,115 (of 22,219 total)
The best way is to restore the database, but there are some other checks you can run. I have an article that lays it all out 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
February 23, 2016 at 5:36 am
I'd just go over to Red-gate.com and get a copy of SQL Search[/url]. It's a free tool and will do pretty much any kind of search you need against 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
February 23, 2016 at 5:35 am
Not really. Something is up at the TFS level. It should lock the ability of more than one person to check out a given file. It won't affect what you...
"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
February 23, 2016 at 4:28 am
Well, it's still going to work on the files locally, but they should be locked from others working on it. You won't be saving directly to the 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
February 22, 2016 at 11:34 am
Ah, so using SQL Server Data Tools to do the database? You should still be able to check out exclusive through Visual Studio. It's just how you do the checkout...
"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
February 22, 2016 at 7:36 am
What tool are you using to perform the checkouts?
"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
February 22, 2016 at 6:45 am
There are the PASS Virtual Chapters. They cover topics other than SQL Server. After that, for non-Data Platform stuff, I'd suggest searching through meetup[/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
February 22, 2016 at 4:09 am
SQL Saturday, already linked, is one great resource to expand your learning. If you're trying to track down a local user group, I recommend searching through the Chapters list at...
"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
February 22, 2016 at 4:07 am
Is replication failing? If so, even if you have log backups, that would cause the log to fill. Do you have log backups? That wasn't mentioned. In addition to reading...
"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
February 22, 2016 at 3:59 am
Jeff Moden (2/18/2016)
"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
February 18, 2016 at 1:48 pm
It's what Gail said. Those are local variables. They're not parameters. Local variables are not sniffed the way parameters are except in the case of a statement level recompile. 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
February 17, 2016 at 4:20 pm
Try doing a refresh? Maybe you have an old version of SSMS (just because you patch the server, doesn't patch your client software)?
You should be able to see database objects.
"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
February 17, 2016 at 4:17 pm
I think Jo got it right at the start. If you're exporting and importing, as opposed to using backup and restore, then you're looking at differences in the statistics based...
"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
February 17, 2016 at 10:26 am
Same as anything else, use the dynamic management views and system views. They're documented here at MSDN.
"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
February 16, 2016 at 5:14 pm
Those are probably the built-in sessions. System_health is running on all 2008 and better systems. If you have availability groups on the server, you'll also get a session for those....
"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
February 16, 2016 at 3:53 pm
Viewing 15 posts - 5,101 through 5,115 (of 22,219 total)