Viewing 15 posts - 13,651 through 13,665 (of 22,213 total)
On #3, if you change the data type on existing data, you face the possibility of data loss, which, for most businesses, is a bad thing. So when do this...
January 11, 2011 at 7:05 am
As much as I love people reading my book, I'm not sure that one will help.
What will happen when the CPU is maxed out? Processes start to wait for CPU...
January 11, 2011 at 7:02 am
SequelSurfer (1/11/2011)
sqlbuddy123 (1/10/2011)
January 11, 2011 at 5:47 am
Donalith (1/10/2011)
It doesn't use any disk space? Is it faster or slower than a regular, disk-using, restore?
Restore time is about the same as the regular restore because most of that...
January 11, 2011 at 5:44 am
JMSM (1/10/2011)
I'm really but really sorry, but i'm completely lost and hope that anyone explain me what should i do like if i was a donkey :crying:
Sorry but i...
January 10, 2011 at 12:16 pm
Craig Farrell (1/10/2011)
Grant Fritchey (1/10/2011)
January 10, 2011 at 12:07 pm
Blocking is caused when a process takes an extended lock on a resource, a page, row, table, database, that other processes needs. The other processes are blocked until the resources...
January 10, 2011 at 8:58 am
True. Something like Red Gate's Virtual Restore allows you to access the data on a backup directly without even restoring the database.
January 10, 2011 at 8:29 am
JMSM (1/10/2011)
I've attached the execution plan and the code of both views, the oldest and the new one.
I've change yet the column names, and the tablename on both views.
Thanks...
January 10, 2011 at 8:04 am
You do know that hiring managers can perform searches for people's names. If this comes up on a search, you're guaranteed to not get the job because no one is...
January 10, 2011 at 7:46 am
It depends so much on what you have available. There are lots of things you can do, but without knowing what you have, what the situation is... There's no way...
January 10, 2011 at 7:19 am
hemanth T (1/9/2011)
system encountered exception error no:266
with following message.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is...
January 10, 2011 at 7:05 am
They had to have been referring to ad hoc, client side code. A parameterized query or a stored procedure are basically the same thing, so you're already on the right...
January 10, 2011 at 7:01 am
Who knows. Could be anything. Maybe it's a nested transaction and starting another one causes an error. I'd just place it inside the TRY statement, just in case. One example,...
January 9, 2011 at 2:49 pm
I wouldn't necessarily jump off a building yet. There is specialization, and this product is so absolutely huge, that no one is going to know everything. But you can be...
January 9, 2011 at 9:25 am
Viewing 15 posts - 13,651 through 13,665 (of 22,213 total)