Viewing 15 posts - 13,036 through 13,050 (of 49,552 total)
Bear in mind though it's trivial to spoof the application name.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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*...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2013 at 2:12 pm
John_P (5/22/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2013 at 8:21 am
Viewing 15 posts - 13,036 through 13,050 (of 49,552 total)