Viewing 15 posts - 196 through 210 (of 458 total)
John Mitchell-245523 (9/2/2015)
Goodness! If the IT department isn't fulfilling one of its most important roles by taking backups, then that needs escalating to the very top, doesn't it?John
Backups are...
September 2, 2015 at 8:38 am
John Mitchell-245523 (9/2/2015)
September 2, 2015 at 7:53 am
Jeff Moden (8/14/2015)
pdanes (8/14/2015)
August 15, 2015 at 3:38 am
If you are manually running some code in SSMS, table variables have the additional advantage of being generated fresh on every run. Temp tables stay around, and you have to...
August 14, 2015 at 6:23 am
Well, I've made some progres on it. I had to manually change a bunch of permissions, and I got it running again. However, I have no idea why something that...
June 21, 2015 at 2:29 pm
ScottPletcher (6/19/2015)
When you use "EXECUTE AS OWNER" the owner cannot be...
June 19, 2015 at 3:38 pm
Joie Andrew (6/19/2015)
Was the sa login recently disabled or renamed on the instance where your development is pointing to?
As far as I know, nothing has changed. At least, I haven't...
June 19, 2015 at 1:27 pm
Mode con works, Format-Table -wrap still truncates. Thank you both.
June 3, 2015 at 11:29 pm
Alvin Ramard (6/3/2015)
One option would be to send the results to file. I know I'd like a better option, but it's better than nothing.
I'd like to keep it in...
June 3, 2015 at 3:57 pm
ZZartin (6/3/2015)
Unless real time updates to the view are needed could you just run a scheduled job every however often to populate your temp table instead of using triggers?
Yes, I...
June 3, 2015 at 12:28 pm
Not a bad idea, but that someone would most likely be me, so I think it's better to build triggers that prevent the situation from occurring in the first...
May 26, 2015 at 12:19 am
Now that I think about it some more, I'm not even sure that it's possible to enforce an 'exactly one' condition, even with code. It would never be possible for...
May 25, 2015 at 8:36 am
spaghettidba (5/25/2015)
You could also use indexed views. I have a blog post on the subject here[/url].
Thanks for the tip. I'm looking at your blog, but it's a bit technical and...
May 25, 2015 at 7:48 am
GilaMonster (5/25/2015)
CREATE UNIQUE INDEX idx_TableOfClovekNames_ClovekAutoIDON TableOfClovekNames (ClovekAutoID)
WHERE JeHlavni = 1
The unique requirement on that only applies to rows where JeHlavni is 1, and it forces that there may not be...
May 25, 2015 at 7:46 am
GilaMonster (5/25/2015)
You want to ensure that there is only ever one row with JeHlavni = 1 for each...
May 25, 2015 at 7:10 am
Viewing 15 posts - 196 through 210 (of 458 total)