Viewing 15 posts - 6,241 through 6,255 (of 9,728 total)
It depends.
I know that answer blows, but it really does depend.
1) Database shrinking or File shrinking?
2) Through the GUI or a DBCC command?
3) If you used the DBCC command, please...
March 23, 2011 at 8:16 am
HowardW (3/23/2011)
Is the SQL Server Browser Service Running?
It wasn't. Just started it, retried starting SQL Server Agent Service and got the same error message.
March 23, 2011 at 8:13 am
Again, what Gail said.
But in my original analogy, the parts of the plate covered with cookies were the active VLFs and the empty parts of the plate were the inactive...
March 23, 2011 at 8:07 am
I've just opened up a new connect issue with the details of the SQLAgent.Out.
EDIT: OS is Vista Business 32 bit.
Here's what I've posted:
"2011-03-18 13:34:41 - ! [298] SQLServer Error: 65535,...
March 23, 2011 at 7:56 am
Gah. This is seriously annoying. Neither Repair nor an uninstall / reinstall fixed the issue.
Any more thoughts?
March 23, 2011 at 7:38 am
Kokila, thanks for the advice, but as stated above, the service account is running under full Sysadmin permissions (which would be a complete no-no if I were running this on...
March 23, 2011 at 5:25 am
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
Viewing 15 posts - 6,241 through 6,255 (of 9,728 total)