Viewing 15 posts - 6,241 through 6,255 (of 9,722 total)
I've never even heard of anyone executing a query plan before. Just a query.
Are you trying to execute a query with a specific query execution plan instead of letting...
March 23, 2011 at 5:24 am
Add your data type sizes (per row) and multiple by the number of rows in each table. This will get you the uncompressed size.
Don't forget to add the overhead...
March 23, 2011 at 5:21 am
Self-study has always worked best for me as I tend to forget class-taught items a week after the class unless I actually practice them.
Getting books and working through the exercises...
March 23, 2011 at 5:20 am
GilaMonster (3/23/2011)
Brandie Tarvin (3/23/2011)
jcrawf02 (3/22/2011)
After reading that thread, I want cookies. Thanks a lot, Brandie.Hee. I am so evil. @=)
I want cookies too, and I love that analogy.
Still bad info...
March 23, 2011 at 5:18 am
What Gail said.
Re-read the cookie analogy.
March 23, 2011 at 5:15 am
Can you believe I still have my SQL 2000 System Tables Map? @=)
You can get user / login information from the following tables:
sysremotelogins (to verify linked servers, etc.)
syslogins (gets login...
March 23, 2011 at 5:13 am
Well, progress didn't help me much. There's still not a whole lot out there. But I'm attempting to repair the install to see if that works.
If not, I guess I'm...
March 23, 2011 at 5:04 am
jcrawf02 (3/22/2011)
After reading that thread, I want cookies. Thanks a lot, Brandie.
Hee. I am so evil. @=)
March 23, 2011 at 5:00 am
You're welcome. I hope the analogy made things easier to understand for you.
March 22, 2011 at 12:43 pm
Sachin Nandanwar (3/22/2011)
Brandie Tarvin (3/22/2011)
A checkpoint doesn't change the size of the log files. It just marks a section of the log as ready to be reused by the transaction...
March 22, 2011 at 12:34 pm
Sachin Nandanwar (3/22/2011)
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
So when a checkpoint...
March 22, 2011 at 12:17 pm
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
Hence the reason, Sachin, why I...
March 22, 2011 at 11:54 am
Jason, you need to change that out for the image of Boo in her monster costume. @=)
March 22, 2011 at 11:51 am
Oh, hey, completely non-SQL related link:
If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
March 22, 2011 at 11:39 am
GilaMonster (3/22/2011)
Brandie Tarvin (3/22/2011)
March 22, 2011 at 11:38 am
Viewing 15 posts - 6,241 through 6,255 (of 9,722 total)