Viewing 15 posts - 4,351 through 4,365 (of 22,224 total)
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
djj (9/30/2016)
Greg Edwards-268690 (9/29/2016)
Setting them up in several stages, where you can avoid...
"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 5:23 am
Sounds like you're doing a good job. Keep it up. Focus on the metrics to drive your decisions. Take a look at Gail Shaw's blog post on "catch-all" queries. That...
"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 29, 2016 at 12:12 pm
Mike Scalise (9/29/2016)
Grant Fritchey (9/29/2016)
I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do...
"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 29, 2016 at 12:06 pm
Viewing 15 posts - 4,351 through 4,365 (of 22,224 total)