Viewing 15 posts - 13,171 through 13,185 (of 22,214 total)
I would strongly suggest you take a look at SQL Compare[/url] from Red Gate (yes, I work for them). But, you need to know, while SQL Compare works wonders, it's...
February 21, 2011 at 5:49 am
I'm with Lutz. I think you'd be better off using an Identity column, even make that the primary key, and then have a calculated column or just put it into...
February 21, 2011 at 5:43 am
I write a lot more TSQL than I click on the GUI. I mainly use the object explorer window to keep track of all the tables & columns, but other...
February 20, 2011 at 8:54 pm
nico van niekerk (2/20/2011)
February 20, 2011 at 7:05 pm
There are a lot ways you can go about working with developers on databases in a team environment. You'll have to figure out what works best for you. The one...
February 20, 2011 at 4:14 pm
WayneS (2/20/2011)
@Grant, Steve, Jeff - any chance...
February 20, 2011 at 4:09 pm
Hard to say, I don't know your systems or the volumes involved. I would only split to another database if I thought the load required it.
February 20, 2011 at 9:10 am
To connect to that, you have to supply the machine name as well as the instance name. MachineName\SQLServer from what you showed ought to do the trick. I suspect you're...
February 20, 2011 at 5:45 am
I suspect everyone has their own best practice. I only break down schemas into either discrete security areas, where I'm going to treat some tables differently than others for security,...
February 20, 2011 at 5:43 am
Just a side note, if your reindex jobs don't finish and you stop them, isn't the problem just going to spiral? Won't every night it get, maybe, just a little...
February 20, 2011 at 5:39 am
That's the right approach, if, your client and their business model just wants the historical aggregation information. If they want more, as you say, you're stuck. I can't tell you...
February 20, 2011 at 5:36 am
Best advice I can give you is to read the documentation so you know what you're doing. It's available online here.
Do the standalone install. By and large if you accept...
February 20, 2011 at 5:30 am
Craig Farrell (2/20/2011)
For anyone curious, my opinions on the SQLSaturday #47 event in Phoenix.http://www.sqlservercentral.com/Forums/Topic1066836-1199-1.aspx
All in all, a very satisfying day.
Sounds like a good event. Sorry I couldn't make that one.
February 20, 2011 at 5:26 am
You're retrieving 92k out of 95k from the table. There's no real way to speed that type of data access up. You're going to get scans, and you're dependent on...
February 19, 2011 at 8:58 am
mazzz (2/18/2011)
The CXPACKETs as far as I could tell were waiting on PAGEIOLATCHes. The...
February 18, 2011 at 10:54 am
Viewing 15 posts - 13,171 through 13,185 (of 22,214 total)