Viewing 15 posts - 1,966 through 1,980 (of 49,557 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
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...
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?
December 20, 2016 at 5:34 am
BWFC (12/20/2016)
Grant Fritchey (12/20/2016)
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...
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,...
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...
December 20, 2016 at 4:00 am
Looks like the precons are being announced now.
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...
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...
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....
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...
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.
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...
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...
December 19, 2016 at 8:21 am
Viewing 15 posts - 1,966 through 1,980 (of 49,557 total)