Viewing 15 posts - 1,966 through 1,980 (of 49,552 total)
The answers in the last two posts will work fine, but they have an inherent performance problem. Have a look at the first section of https://www.simple-talk.com/content/article.aspx?article=2280
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
December 20, 2016 at 6:50 am
Siberian Khatru (12/20/2016)
so I restored the database to a point in time AFTER the delete(s) was done and tried the techniques found here
And there's the problem.
When you restore a...
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
December 20, 2016 at 6:45 am
On a different note, can someone who's up to doing some hand-holding today have a look at http://www.sqlservercentral.com/Forums/Topic1844193-1550-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
December 20, 2016 at 5:34 am
BWFC (12/20/2016)
Grant Fritchey (12/20/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
December 20, 2016 at 5:23 am
Then you back up the user databases and restore them on the other server.
Don't backup and restore the system databases though, script out logins, jobs, server-level permissions, linked servers...
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
December 20, 2016 at 5:22 am
Um, considering that I said the sweet spot for file stream is >1MB, and the max a varbinary(4000) can store is 4k, I'm not even sure why you'd consider it,...
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
December 20, 2016 at 4:02 am
Again, depends on whether the optimiser chooses to use the indexed view itself (which is materialised and stored as if it was a table), or ignore the materialised view and...
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
December 20, 2016 at 4:00 am
Looks like the precons are being announced now.
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
December 20, 2016 at 3:00 am
The IMAGE data type is deprecated, has been since SQL 2005 and really should not be used any longer (and can't be marked as File Stream).
Use VARBINARY(MAX)
Whether you store 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
December 20, 2016 at 2:43 am
Have a look at the first section of https://www.simple-talk.com/content/article.aspx?article=2280
And when you call a procedure with optional parameters, you need to specify the parameter name.
EXEC GetDetails @AccountID = '101'
EXEC GetDetails...
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
December 20, 2016 at 2:39 am
MickyD (12/19/2016)
Any one done this , got any ideas of how to sell to business users and Devs as an approach to take ?
For the performance testing, use Query Store....
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
December 20, 2016 at 2:37 am
m.sams (12/16/2016)
The primary key still gets used in some joins, but there is always a key lookup because you can't include columns on a primary key.
Is the key lookup a...
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
December 20, 2016 at 2:36 am
Beatrix Kiddo (12/20/2016)
I want to go, but oh man, Telford.
It's not too bad. Small, yes, but most of the day will be spent at the venue.
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
December 20, 2016 at 2:28 am
Scott In Sydney (12/19/2016)
1) In this scenario, are there performance gains from adding indexes to the view?
Unlikely. The typical use case for indexes on views is to materialise a complex...
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
December 20, 2016 at 2:27 am
You don't need to, they can't be changed and you wouldn't be able to 'restore' them.
What are you trying to do here?
Procedures (and views, functions, etc) in source control...
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
December 19, 2016 at 8:21 am
Viewing 15 posts - 1,966 through 1,980 (of 49,552 total)