Viewing 15 posts - 4,351 through 4,365 (of 22,227 total)
hurricaneDBA (10/5/2016)
Ill discuss it with management to run them every hour.
If I setup the backups to run every...
"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
October 6, 2016 at 5:11 am
I'm with Kevin on still being a little new on the memory optimized stuff. Most of my testing and training suggests you might be better off with a hash key...
"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
October 6, 2016 at 5:02 am
Tava (10/6/2016)
Is it not better to do both physical and logical? If you had too choose would...
"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
October 6, 2016 at 4:59 am
I just cancelled a trip for the first time in almost six years of travelling thanks to this hurricane. I am not pleased.
I hope everyone down in Florida, and especially...
"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
October 5, 2016 at 10:18 am
george sibbald (10/5/2016)
I made it into the top 30 posters at one point so I did my...
"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
October 5, 2016 at 5:27 am
Eirikur Eiriksson (10/5/2016)
Any upgrades available for the Crystal Ball?😎
And the latest question on the indexes... oh my.
"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
October 5, 2016 at 4:45 am
ramyours2003 (10/5/2016)
thanks for the mail , what is the reason of not creating index on 32 bit system?
You tell us. Indexes are as vital to a 32 bit system as...
"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
October 5, 2016 at 4:44 am
Grab a copy of my book on performance tuning and start reading. Get a copy of Gail's book on being an Accidental DBA and start reading.
One system change 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
October 5, 2016 at 4:23 am
Since you're in 2014, use extended events. You should absolutely be able to capture the parameter values on individual calls. If rpc_complete is not giving you the information you're looking...
"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
October 4, 2016 at 7:47 am
There is not currently a mechanism released for querying Azure databases from the Portal UI. However, you can try clicking on the Tools menu from a given database. There are...
"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
October 3, 2016 at 10:47 am
Yeah, it's normal. Here's the description of that procedure. A suspended status just means that at the moment you're calling it, it's waiting on resources and will restart when it's...
"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
October 3, 2016 at 6:05 am
george sibbald (10/3/2016)
not used it myself but wondering if dacpac will help herehttps://msdn.microsoft.com/en-gb/library/ee210546(v=sql.110).aspx
right click database, tasks, extract data-tier application
That could work, but you're going to want to automate it 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
October 3, 2016 at 6:01 am
If you only want to move all the structures and no data, I'd suggest taking a look at SQL Compare [/url]from Redgate (disclosure: my employer). If I had 700+ databases...
"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
October 3, 2016 at 4:26 am
Hugo Kornelis (10/2/2016)
Eirikur Eiriksson (10/2/2016)
BLOB_EATER (10/2/2016)
Into my 19th hour for the weekend shift decided to google (Gone off bing) well know SQL Server people and found this (attached).... Im scared.
Don't...
"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
October 3, 2016 at 4:14 am
You also won't be able to do a backup and restore going down in versions.
"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
September 30, 2016 at 8:26 am
Viewing 15 posts - 4,351 through 4,365 (of 22,227 total)