Viewing 15 posts - 11,581 through 11,595 (of 22,214 total)
Just a side note, if you don't have backups of this database, are you running backups of your other databases? If not, in addition to worrying about getting this one...
December 1, 2011 at 7:51 am
I'm sorry to say, there's no easy way to explain this. I've written two different books, one on query tuning and one on reading execution plans. There's that much material...
December 1, 2011 at 5:11 am
Lexa (11/30/2011)
1. UPDLOCK [what happens when used in "insert table1 select * from...
December 1, 2011 at 5:07 am
If you're using Transparent Data Encryption, and the key is properly installed on the server, you should just be able to query the data. If not, I think this is...
December 1, 2011 at 5:02 am
Most of the software out there allows you to download it and try it out. Each one offers different sets of details and has some different monitoring mechanisms. I'd suggest...
December 1, 2011 at 4:52 am
matt.newman (11/30/2011)
November 30, 2011 at 12:16 pm
Having done the method of trying to maintain "clean" database copies that are then moved around for restore purposes and having had four (4) times the amount of disk storage...
November 30, 2011 at 11:04 am
Same goes with plugging in the Cumulative Updates after you get to the latest service pack. If you don't know what's causing your slow down, you might see a fix...
November 30, 2011 at 10:55 am
Any increase in performance from one SP to the next is most likely to be extremely marginal. If you're hitting performance issues, you need to do the hard work of...
November 30, 2011 at 7:27 am
I also recommend starting with Gail Shaw's articles linked above. It's an excellent place to get started. I'd also suggest you pick up a copy of my book on exactly...
November 30, 2011 at 7:25 am
The one wrinkle that I might add to it would be to set up these servers as a virtual and then copy that out to the developers workstations, but I...
November 30, 2011 at 4:49 am
Tom Brown (11/29/2011)
What is the error when you try create table in ssms?
That's a permissions issue. Were you logged in under a different account? Did your access get changed?...
November 29, 2011 at 7:08 am
I would generally go with JOIN and CROSS APPLY to solve these types of issues. Assuming you can do a single statement table valued function, that might work too. For...
November 29, 2011 at 7:06 am
Hmmm... Not sure then. Is FILESTREAM still configured to that drive? It might be interfering with using it for data files. Can you restore the database using WITH MOVE and...
November 29, 2011 at 5:53 am
It could be a security issue. Does the account that your SQL Server instance is running under have access to that drive? You might, but does SQL Server?
November 29, 2011 at 5:43 am
Viewing 15 posts - 11,581 through 11,595 (of 22,214 total)