Viewing 15 posts - 8,296 through 8,310 (of 39,803 total)
Beatrix Kiddo (4/12/2016)
I'd love to go, but no budget. It looks great.
Saturday is free. Other than the train.
April 12, 2016 at 9:15 am
Gary Varga (4/12/2016)
SQL Bits XV looks really exciting but unfortunately I...
April 12, 2016 at 9:15 am
Carlo Romagnano (4/11/2016)
Steve, the right event is "DROP TABLE" instead of "DELETE TABLE".
That's an incorrect answer.
April 12, 2016 at 9:14 am
I also used triggers once to separate out replication. We had a Sales database and an accounting database. We did this:
Sales.dbo.SalesOrder table
|-> trigger to insert into...
April 12, 2016 at 9:11 am
Sorry, it's a good abstract.
April 12, 2016 at 9:09 am
Good luck.
I don't think there's necessarily anything wrong, but if it's a busy system, SQL might struggle. IF you're Enterprise, you can use In-Memory.
I'd start looking at Redis. I see...
April 12, 2016 at 9:08 am
Andrew..Peterson (4/11/2016)
crlewis42 (4/11/2016)
April 12, 2016 at 9:06 am
colin.s.allen (4/12/2016)
If it isn't completely automated it won't work. It needs something along the lines of pestering the creator automatically until they document it or quarantining anything not registered.
This can't...
April 12, 2016 at 9:06 am
Rod at work (4/11/2016)
April 12, 2016 at 9:05 am
I agree with Hugo, but I'll add one more thing against triggers. They're hidden.
We see them rarely, they don't easily appear in SSMS, and it's easy to forget they're in...
April 8, 2016 at 11:10 am
I'd second what Jacob said. Working with SQL Server is always remote. Even if you are on the console, SSMS makes a remote connection, so setup networking and work from...
April 8, 2016 at 11:01 am
You can win a conference pass to SQL Bits. Post a review of a previous event, or of one of the videos from a previous event (available online) : http://sqlbits.us4.list-manage.com/track/click?u=3e64686fd47743f72cf7ae22a&id=8d1ba01f21&e=3d669e3feb
April 8, 2016 at 9:55 am
I'll disagree with Jeff. Depending on how often and how data is addressed, I think it's fine to keep blob data around. I might normalize pieces of it, but there...
April 8, 2016 at 8:59 am
BL0B_EATER (4/8/2016)
April 8, 2016 at 8:33 am
Chocolatey is amazing. If you haven't tried it, I recommend it. I've used it more and more, grabbing software as I need it rather than trying to get things setup...
April 7, 2016 at 2:59 pm
Viewing 15 posts - 8,296 through 8,310 (of 39,803 total)