Viewing 15 posts - 10,021 through 10,035 (of 22,213 total)
Not sure. Is it possible it's still running? Blocked maybe? I have seen that happen, on more than one unfortunate occasion.
February 12, 2013 at 4:01 am
Chrissy321 (2/11/2013)
Lately I put everything in a schema. Is this a reasonable statement as far as a best practice?...
February 12, 2013 at 3:43 am
Not sure. Reading the KB, it could be interpreted to only apply to CU & hot fixes, but I don't have a definitive answer there.
February 11, 2013 at 9:09 am
I'd monitor the server for a couple of days (to a couple of weeks if I could) to see if the database is being accessed. Then back it up. Then...
February 11, 2013 at 8:50 am
They all can be. Makes things sloppy in my opinion. However, if you are dealing very large numbers of objects, for example, I saw this with stored procedures when we...
February 11, 2013 at 5:08 am
You can have a single NULL value there. That's it. More than one, and it's not unique. You could try a filtered index instead.
February 11, 2013 at 5:01 am
You should be aware that most changes to the optimizer, especially the ones that lead to plan instability, are not actually turned on when you install a service pack. Read...
February 11, 2013 at 5:00 am
If you are trying to learn T-SQL, you can't go very far wrong picking up Itzik Ben-Gan's book. He has a fundamentals book and the Inside book.
I don't know of...
February 11, 2013 at 4:49 am
Jeff Moden (2/10/2013)
Steve Jones - SSC Editor (12/3/2010)
No hurry on any of these.
I guess that's a good thing. Grant, did you ever get yours done? I know I'm...
February 11, 2013 at 4:36 am
meridius10 (2/10/2013)
February 10, 2013 at 9:20 am
If you say "SQL" and "SQL Server" as part your knowledge set, I'd say you know T-SQL. Do you know the new 2012 paging methods? I'm not up on those,...
February 10, 2013 at 5:11 am
Yes you can. Each one will run the checksum calculation on the pages before and after they are written to disk to help ensure that what was read from your...
February 10, 2013 at 5:07 am
Sure, but I wasn't aware that the encryption process would actually make consistent output pages that could be deduped. It implies that reverse engineering of the encryption process is just...
February 8, 2013 at 11:22 am
Brandie Tarvin (2/8/2013)
It is morning, and my boss wants "butt in chair" work.
Sigh. Sometimes I hate my life....
February 8, 2013 at 8:16 am
Sounds mostly reasonable, yes.
February 8, 2013 at 8:09 am
Viewing 15 posts - 10,021 through 10,035 (of 22,213 total)