Viewing 15 posts - 3,691 through 3,705 (of 49,552 total)
Both scenarios, either 5 minutes or 0 minutes, depending whether you can back up the tail of the log or not.
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
February 1, 2016 at 3:03 pm
Personally at this point in time, I'd be planning for 2016 and starting the testing now (on the CTP), and you MUST test. There have been too many core changes...
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
February 1, 2016 at 8:38 am
JonnoJ (2/1/2016)
No it's like I said I'm curious how MS sees it, it doesn't matter how we see it.
Then call Microsoft and ask. No one here can tell you 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
February 1, 2016 at 8:36 am
Anyone? Although this looks to me like a case of 'give me the answer I want'.
http://www.sqlservercentral.com/Forums/Topic1757296-3411-1.aspx
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
February 1, 2016 at 8:35 am
It's not whether you see it as production data or not. Developer edition is licensed for development and testing only.
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
February 1, 2016 at 8:28 am
Developer is licensed for development and testing purposes only, and it's licensed per user, not per server, so anyone why uses the server must have a developer license.
2) is testing,...
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
February 1, 2016 at 7:00 am
Ray K (1/31/2016)
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
February 1, 2016 at 6:33 am
That's exactly what the WHERE clause I wrote for you will do.
Oh, and to emphasise, you MUST use the OPTION(RECOMPILE) clause as well.
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
February 1, 2016 at 6:10 am
If @ZoneId is set to 1, then you want just the one row, if it's null you want all 4?
WHERE (@ZoneID IS NULL OR ZoneID = @ZoneID)
OPTION(RECOMPILE)
The option(recompile is very...
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
February 1, 2016 at 5:00 am
Yes, but it's going to be hard to give specifics without seeing the code.
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
February 1, 2016 at 2:40 am
WhiteLotus (1/31/2016)
My question is : Can we still optimize this query ?
There's nothing there to optimise. It's a read of an entire table. There's no predicates that can...
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
February 1, 2016 at 2:27 am
This will return the string before the last backslash. It'll work if there's more than 2.
DECLARE @Str VARCHAR(200) = 'W:\ABC\F1.bak'
SELECT LEFT(@Str, LEN(@Str) - CHARINDEX('\', REVERSE(@Str)))
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
February 1, 2016 at 1:57 am
Ed Wagner (1/31/2016)
WayneS (1/31/2016)
GilaMonster (1/30/2016)
Ed Wagner (1/29/2016)
Is it really that much better than SSMS intellsense? I'm asking because I don't know; not trying to start a riot.
Oh,...
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
February 1, 2016 at 1:33 am
dxu (1/31/2016)
Run DBCC CHECKTABLE.
And have you? What are the results?
What's the exact message you're getting from the log backups?
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
February 1, 2016 at 1:27 am
With that little information, no.
What does the alert even mean?
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
January 31, 2016 at 5:58 am
Viewing 15 posts - 3,691 through 3,705 (of 49,552 total)