Viewing 15 posts - 2,881 through 2,895 (of 18,926 total)
zaleeu (9/8/2011)
Okay, time to figure this out then.Cheers !
😛
HTH, I'm not trying to be thick or anything. I just want to make sure you can support that code in...
September 8, 2011 at 11:11 am
That might give you some ideas.
SELECT
T.name,
STUFF((
SELECT
...
September 8, 2011 at 11:09 am
Lowell (9/8/2011)
I gotta know, what is in that Lowell_used_columns file? i'm sure i have the same script saved, but I dunno what yours...
September 8, 2011 at 11:07 am
zaleeu (9/8/2011)
Nope, you lost me 🙂I dont see any place where you mention the name of the table. (Customers)
Can't write this one for you. While this is a simple...
September 8, 2011 at 11:05 am
Krasavita (9/8/2011)
I re started server and my temp db got very 111.38 MB small, but I would like to monitor and see why it got so big before.
We told you...
September 8, 2011 at 11:03 am
ps. (9/8/2011)
In fact i shud write the names too 🙂Glenn Berry i remember.. but hard to find actual owners for all queries 🙁
That's only my desktop (one of them anyways)....
September 8, 2011 at 11:00 am
zaleeu (9/8/2011)
OOPS I Posted in the Server 2005 area.Sorry.
Anyway ..
Thanks for the reply. Will try that.
Won't matter for this one :-).
September 8, 2011 at 10:52 am
Krasavita (9/8/2011)
I am restoring as a new database
What does the script I posted returned?
September 8, 2011 at 10:51 am
Use a calendar table.
SELECT COUNT(*), Month FROM dbo.Calendar WHERE dt BETWEEN @Start AND @End GROUP BY Month
September 8, 2011 at 10:51 am
ps. (9/8/2011)
Ninja's_RGR'us (9/8/2011)
I did and now I don't know where I got it from :-D.
I'll write your name at the top of the notepad file;-)
I have done this only one...
September 8, 2011 at 10:49 am
I use this, then I pivot on the presentation layer.
SELECT
T.name,
STUFF((
SELECT
...
September 8, 2011 at 10:47 am
GilaMonster (9/8/2011)
I've definitely seen it run 'forever' before. Maybe a different version of SQL.
We definitely believe you on this. Apparently this is a "it depends" answer.
Now only if the...
September 8, 2011 at 10:45 am
He edited his post, it's the one prior to this one. There was 2 rows for 200 MB so I just rounded :-D.
Ninja's_RGR'us (9/7/2011)
September 8, 2011 at 10:42 am
:
Grant Fritchey (9/8/2011)
Ninja's_RGR'us (9/8/2011)
I'm a moron, don't listen to me. Anything I say can destroy your servers and have you fired for doing...
September 8, 2011 at 10:40 am
ps. (9/8/2011)
GilaMonster (9/8/2011)
ps. (9/8/2011)
GilaMonster (9/8/2011)
Restoring over an existing database that is in use? If so, the restore can't even start until exclusive access is obtained on the DB.
SQL throws error...
September 8, 2011 at 10:39 am
Viewing 15 posts - 2,881 through 2,895 (of 18,926 total)