Viewing 15 posts - 7,876 through 7,890 (of 22,214 total)
There are two kinds of execution plans, estimated and actual. To get an estimated plan inside SQL Server Management Studio, you simply type:
EXEC myNewProc 'myparameter';
Highlight that command and within Management...
June 27, 2014 at 4:37 am
Microsoft and the Books Online are our bestest friends in the world.
June 27, 2014 at 4:30 am
No, it should work on 2012. It would have been a good idea to get the entire message and everything that it said is incompatible. But according to Microsoft, it's...
June 26, 2014 at 12:41 pm
I forgot about PowerShell. You need to enable permissions to that in addition to giving them the access to the locations of the backups. I'd also enable remoting for PowerShell....
June 26, 2014 at 11:47 am
Probably not much needed at all most of the time. You do need access to the file system to look at the backup files and any other load or...
June 26, 2014 at 11:19 am
I'm back where I was. I'd break it down into three tables, one to define the owner, one to define the competency and one to relate them to each other.
June 26, 2014 at 3:30 am
I trust Perry on the structural side of things like this. If he says you literally can't do it, you probably can't. I'm pretty much in the camp of I...
June 26, 2014 at 3:28 am
Generally, because of how SQL Server stores and retrieves data, it's a good idea on most tables to have a clustered index. Because of how clustered indexes are stored, it's...
June 26, 2014 at 3:17 am
If they're low on space, yeah, I'd turn on auto grow, or maybe just go ahead and give them some head room now if you have the disk space to...
June 26, 2014 at 3:13 am
Nice job figuring it out. And thanks for posting the solution so anyone else who finds the question knows what you did to solve it.
June 25, 2014 at 3:58 pm
I agree with everyone else, make sure the backups are in place. I'd probably shut down & startup using PowerShell just because I could do all the servers at once.
June 25, 2014 at 3:57 pm
Nuts, duplicate question. I said the same thing at the other location.
Please don't cross post. It just confuses conversations. Most of us look at multiple forums anyway.
June 25, 2014 at 3:53 pm
I wouldn't put SSDT on a production machine at all. It's a development platform. It goes on your laptop or a shared desktop or something, not on production.
June 25, 2014 at 3:52 pm
There are some minor improvements to code completion in the query window if that's the kind of thing you're looking for. They've also added some typing functionality that's useful. You...
June 25, 2014 at 3:51 pm
Lynn Pettis (6/25/2014)
Really? Just because SQL Server setup defaults to a CI collation that makes it the "DEFAULT" collation?I give up.
Ha! Well, yeah, I suppose I would refer to...
June 25, 2014 at 3:33 pm
Viewing 15 posts - 7,876 through 7,890 (of 22,214 total)