Viewing 15 posts - 4,336 through 4,350 (of 22,211 total)
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
October 3, 2016 at 4:14 am
You also won't be able to do a backup and restore going down in versions.
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...
September 30, 2016 at 5:23 am
Viewing 15 posts - 4,336 through 4,350 (of 22,211 total)