Viewing 15 posts - 6,451 through 6,465 (of 9,720 total)
So you have a file with multiple, repeatable column headers. How is this file generated? Is it automated or does a person fill in the sheet?
EDIT: If automated, what sort...
February 16, 2011 at 10:46 am
Jack Corbett (2/16/2011)
GSquared (2/16/2011)
GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.Who's noon?
No, Who's on first.
I don't know!
Third base!
February 16, 2011 at 8:50 am
You need to check out Gail's blog. She has a very interesting discussion on this one:
http://www.sqlservercentral.com/Forums/Topic415829-338-1.aspx
EDIT: Whoops. The first link was wrong.
http://sqlinthewild.co.za/index.php/2007/12/19/temp-tables-and-table-variables/%5B/url%5D
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/%5B/url%5D
February 16, 2011 at 8:22 am
Fal (2/16/2011)
D'OH!I knew I should've lurked longer. But no, I had to help someone! 😛
Steve.
Aw. It's okay. We won't tar and feather you for being helpful and posting...
February 16, 2011 at 6:50 am
GilaMonster (2/16/2011)
Brandie Tarvin (2/16/2011)
In fact, if the database is online and suspect, a restart might make the db completely unrecoverable.
Not quite.
Restarting SQL when there's a corrupt database could take...
February 16, 2011 at 6:10 am
Sorry. The spelling in your post confused me. All I could understand was "after you answer the question, try restarting."
February 16, 2011 at 5:39 am
Well, since someone broke the "no technical talk in The Thread" rule...
Guess what I discovered this morning? Severity 21 errors can be caused by full disk drives. Nothing's actually...
February 16, 2011 at 5:31 am
Marco V (2/16/2011)
and
before restoring backups.
you can always try if you got the possibility to restart SQL server and hoping it start...
February 16, 2011 at 5:28 am
sqldba_icon (2/15/2011)
In all these i do not see the place where you mentioned "sp_add_jobserver"?
He's referring to a step referenced in his BOL link (click on the word...
February 16, 2011 at 4:40 am
Jamie Longstreet-481950 (2/16/2011)
The brain sleeps when it runs out of energy. Often it is smarter than we are.
Yeah, and supposedly I just woke up from a good night's sleep....
February 16, 2011 at 4:37 am
sqldba_icon (2/15/2011)
simon-811452 (4/9/2010)
This definitely happens when disabling from the GUI (see previous post). The system SP runs another SP, sp_sqlagent_notify, which clears the cache for the job; again, see previous...
February 16, 2011 at 4:34 am
Daniel Bowlin (2/15/2011)
Congratulations on publication.
WOTD: Thanks. @=)
February 16, 2011 at 4:25 am
john.arnott (2/15/2011)
Jamie Longstreet-481950 (2/15/2011)
CONVERT(varchar(8),getdate(),112)='20110215'
because it is easy to remember and there are...
February 16, 2011 at 4:24 am
GilaMonster (2/15/2011)
Brandie Tarvin (2/15/2011)
February 16, 2011 at 4:20 am
Viewing 15 posts - 6,451 through 6,465 (of 9,720 total)