Forum Replies Created
Viewing 15 posts - 4,891 through 4,905 (of 22,224 total)
-
RE: On-Priemise to SQL Azure migration - How to migrate domain users
You have to create an Azure Active Directory service in your Azure account and then federate that with your local Active Directory. AD in Azure SQL DB is in preview...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.'
jacksonandrew321 (4/4/2016)
you must set the database to single user mode before attempting to restore see here: http://www.sqlserverlogexplorer.com/exclusive-access-not-obtained-database-use/%5B/url%5DThis is a two year old thread.
You don't have to set the database to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to print out a SQL statement in SP...?
Do you mean, capture the information? In SQL Server 2008 you can use trace events. In 2012 or greater you use extended events.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How do I Avoid Deadlocks?
I agree with the other answers, so this is just piling on.
Fundamentally, deadlocks are a performance issue. Yeah, if the code is written in such a way that locks occur...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (3/31/2016)
Bucket list item. Made it on stage at major MS conference.
HUZZAH!
Well done.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Query query_plan XML Column in a Table
I have an example on the blog here [/url]that pulls out Missing Index information.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL server 2008 R2 (Performance after installation)
Again, no. There's not enough information to make intelligent suggestions. You've listed an OS and version, SQL Server version, and the fact that you're running on a VM, but not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: mysterious slowdown every 4 minutes
For it to be that precise, something is running a process I'd guess. Do you have monitoring in place to capture query executions? If not, try trace (since you're still...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Confused about Alwayson Availablity group
Beatrix Kiddo (3/31/2016)
Yes. Spend some time reading Perry Whittle's Stairway to AlwaysOn.This
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Extended Events to find out what is hitting a table
Excellent. Glad things worked out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
TomThomson (3/30/2016)
Grant Fritchey (3/30/2016)
TomThomson (3/30/2016)
Can someone who knows how Microsoft has chosen to implement snapshot Isolation take a lppk here? I've answered as best I can, but my answers..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Extended Events to find out what is hitting a table
First, I'd determine if there were stored procedures that could, conceivably, be calling that table. If there are any, it complicates this slightly.
The events you want are sql_batch_complete and rpc_complete...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Do any of you send your SQL backups to the cloud?
I've been doing it for years. I backed up locally (because it's faster) and the used powershell to copy the files out to Azure blob storage. Done.
You can get fancy,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: pager life expectancy is 220 seconds. Would buffer pool extensions help
You can.
I wouldn't necessarily base it on PLE though. What kind of wait statistics are you seeing?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: run a script with different windows user
Another way would be to launch SSMS (or whatever you're using to run you queries) using "Run As" inside of Windows. Right click on the icon.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 4,891 through 4,905 (of 22,224 total)