Viewing 15 posts - 13,036 through 13,050 (of 49,552 total)
Bear in mind though it's trivial to spoof the application name.
May 22, 2013 at 4:29 pm
Grant Fritchey (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?Will an Arkansas tire thumper work?
No idea what one of...
May 22, 2013 at 4:09 pm
Evil Kraig F (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?Don't you own a katana?
Yes, but it'll damage the...
May 22, 2013 at 3:15 pm
AmarettoSlim (5/22/2013)
Can someone explain why SQL Server doesn't support object level recovery in a native manner?
Because doing so would allow a native restore to result in a transactionally inconsistent database...
May 22, 2013 at 3:04 pm
lnardozi 61862 (5/22/2013)
Would a shrink maybe put more of the database into the cache?
No. The only things that go into cache are allocated pages and all shrink does is move...
May 22, 2013 at 3:02 pm
ScottPletcher (5/22/2013)
I think there could be specific cases where it could theoretically happen, depending on the DELETE/INSERT patterns to the heaps and the specific disk allocations.
Cool, when you find one,...
May 22, 2013 at 2:58 pm
ScottPletcher (5/22/2013)
It wasn't "out of context" -- you made an absolute statement, which thus applies to any context.
An absolute statement that you chose to ignore parts of.
I said shrink *alone*...
May 22, 2013 at 2:23 pm
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?
May 22, 2013 at 2:12 pm
John_P (5/22/2013)
May 22, 2013 at 2:10 pm
ScottPletcher (5/22/2013)
GilaMonster (5/21/2013)
Shrink alone can't speed up a query.Isn't that an overly broad assertion?
Only when you quote me out of context.
If, for the sake of argument, some/all of the disk...
May 22, 2013 at 2:04 pm
TheSQLGuru (5/22/2013)
IIRC, shrinking a database will flush the procedure cache, which could result in better plans for queries as they get fired again for the first time.
It doesn't, I just...
May 22, 2013 at 12:22 pm
richard.noordam (5/22/2013)
Cursors lock the tables/views they are using if i'm not incorrect, (one of the reasons not to use a cursor)
Not necessarily.
The reason not to use cursors is because cursors...
May 22, 2013 at 9:49 am
Wait until no portion of the active log is within that file (DBCC LogInfo). Once that's the case, ALTER DATABASE and drop the file.
May 22, 2013 at 8:47 am
Original query form (with some tables I happen to have lying around, around 50k rows in the larger table)
SELECT s.id ,
s.LookupColumn...
May 22, 2013 at 8:43 am
That's not a SQL Server error message. Tried contacting your administrator?
Looks like an AD error. Possibly some service is trying to log on with your account and an incorrect password...
May 22, 2013 at 8:21 am
Viewing 15 posts - 13,036 through 13,050 (of 49,552 total)