Viewing 15 posts - 38,656 through 38,670 (of 49,571 total)
mjarsaniya (6/6/2009)
yes but you have created table t not @t....
I assume you didn't try my code.... If you had and had queried the table variable, you'd have seen it did...
June 6, 2009 at 6:53 am
Do the values in Enterdate have any times associated? If so, that query won't work as it will only match dates that have midnight as their time. If that is...
June 6, 2009 at 5:45 am
Under the job step, go to the Options page and there's a option there to write the job step's output to a file, either overwrite or append.
June 6, 2009 at 5:34 am
SSC and SQLTeam mostly, though far more here than there. Mostly I just watch the corruption-related forum there. On the non-SQL specific also SADeveloper.net (when it's up) and ServerFault.com
Edit: I...
June 6, 2009 at 5:33 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic730180-150-1.aspx
June 6, 2009 at 5:30 am
Does this work?
update t
set number = test.number
FROM @t AS t INNER JOIN test on t.foo=test.foo
p.s. please in future test the sample code that you give us. There were several syntax...
June 6, 2009 at 5:28 am
What does the view's definition currently look like?
June 6, 2009 at 5:03 am
Lynn Pettis (6/5/2009)
June 5, 2009 at 3:17 pm
Lynn Pettis (6/5/2009)
GilaMonster (6/5/2009)
Lynn Pettis (6/5/2009)
Here is another OMG moment.
He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and was...
June 5, 2009 at 3:09 pm
Lynn Pettis (6/5/2009)
Here is another OMG moment.
He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and was told to go...
June 5, 2009 at 2:58 pm
Loner (6/5/2009)
So if the page count is less than 100, even the fragment in percent is high, I don't have to worry about it?
1000 pages. Not 100.
1000 pages is about...
June 5, 2009 at 2:53 pm
ganci.mark (6/5/2009)
Assuming Full Recovery Mode
All recovery modes behave the same. Recovery mode affects how long a transaction remains in the log and, in the case of bulk operations, how much...
June 5, 2009 at 2:51 pm
Maint plans are covered in quite a bit of detail in Books Online. Far more than Lynn or I could go into in a reasonable amount of time. If you...
June 5, 2009 at 2:43 pm
Those indexes are tiny. Fragmentation only really becomes a noticable problem on indexes that have more than 1000 pages. On very, very small indexes, the way the first few pages...
June 5, 2009 at 2:25 pm
Viewing 15 posts - 38,656 through 38,670 (of 49,571 total)