Viewing 15 posts - 17,611 through 17,625 (of 22,202 total)
Yeah, a pretty standard solution for avoiding NULL values.
April 23, 2009 at 6:16 am
The thing is, the query window in SSMS is for manual entry, not automation. It's unlikely they'll automate it when MS is already providing sqlcmd.exe and PowerShell scripts (another option)....
April 23, 2009 at 5:52 am
Actually you can register on the last day of the conference if you want to. I don't know why you would, but it's possible.
April 23, 2009 at 5:17 am
If the data is being pulled from a covering non-clustered index, absolutely. I'm not so sure it would happen during a key lookup.
April 23, 2009 at 5:14 am
Glad I could be at all useful. I'll post anything I find and I'm running up a blog post about this too.
April 22, 2009 at 9:52 am
...and that's when the fight started...
😀
Yeah, that alone is going to cause you performance issues. SQL Server is going to have a hard time resolving everything and optimizing the queries...
April 22, 2009 at 9:23 am
Whoops. Hold on a second. These are all views. We're dealing with nested views right? Ah, that adds a pretty severe level of complexity. It's resolving all the objects on...
April 22, 2009 at 8:47 am
Well, the optimizer is going through a binding process on the query. It has to resolve everything involved before it begins the process of optimization. I suspect that's the step...
April 22, 2009 at 8:44 am
Using sqlcmd would be the 2005ie way to do it. Same for 2008.
April 22, 2009 at 7:43 am
I'm sorry, "first paper"? Do you mean what do you read to get started? Personally I'd suggest you read Craig Mullin's "Database Administration" for a thorough overview of the job....
April 22, 2009 at 4:45 am
I'm not aware of a calculation for determining this. Not only is it dependent on the IO of the system, but it's also going to depend on how much activity...
April 22, 2009 at 4:31 am
If you're creating a table, there should be a toolbar visible at the top of the screen that includes a button called "Manage Indexes and Keys." It shows a little...
April 22, 2009 at 4:29 am
In addition to the suggestions above, it's worth noting that SQL Server 2008 offers Change Data Capture, another way to monitor what was changed in the data.
April 22, 2009 at 4:21 am
That's a huge topic. There have been books written about it (note the bottom of this post 😀 ). Which indexes you place on the tables really depends largely on...
April 22, 2009 at 4:20 am
It's a binary format that SQL Server uses. Why on earth are you worried about that?
April 22, 2009 at 4:16 am
Viewing 15 posts - 17,611 through 17,625 (of 22,202 total)