Viewing 15 posts - 6,511 through 6,525 (of 39,776 total)
Submit a bug on Connect, or find one and vote. They are (finally) making changes to SSMS
August 15, 2017 at 7:27 pm
That's the idea, or at least, to help you see if you have an interest.
August 15, 2017 at 6:14 am
Definitely In. Saw the note, though I think I'm flying that day, so hoping auto draft works well for me.
August 12, 2017 at 11:19 pm
I saw a test, but can't find it now, nor am I allowed since I only had a few minutes before everyone woke up. Now that I think of it,...
August 10, 2017 at 9:35 pm
GETDATE() can also be much faster at scale. If you're just looking for days/hours/minutes/seconds, why not use datetime?
August 10, 2017 at 5:38 pm
My best server room story is a new room built at the nuclear plant for our VAX, DG, and some PC servers. Nice, fancy room, raised floor, separate UPS room,...
August 10, 2017 at 5:33 pm
Luis Cazares - Thursday, August 10, 2017 11:05 AMCan I stop changing my passwords every 90 days, please?
http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987
August 10, 2017 at 5:30 pm
August 6, 2017 at 11:58 am
I agree in many cases, but there are certainly issues where someone gets a breach from company X and then cracks weak passwords used elsewhere. Plenty of secondary attacks do...
August 3, 2017 at 10:28 am
Hey, you can find your own shirts then. I won't need to share if you get picked.
August 3, 2017 at 8:35 am
I'd be safe, and both backup master and script logins.
The collation issue is probably from some join that causes issues. The same thing can happen with joins in...
August 2, 2017 at 9:56 am
Use something like Thom's script. Don't work on a row. Work on a group at a time.
August 2, 2017 at 9:53 am
I tend to agree with Grant. Ultimately, if you need to change to a large value, I don't know if the CHAR->larger VARCHAR is worse than a VARCHAR->larger VARCHAR. In...
August 2, 2017 at 9:37 am
What Gail said.
These are separate constructs. Transactions ensure that code is all run together or none of it. If you have a single update, there's a transaction...
August 2, 2017 at 9:34 am
You could use a CTE
With myCTE
as
(Select ID, TransactionTime, Points From Members Where Points >= 20)
select *
from myCTE
inner join someothertable a
August 2, 2017 at 9:32 am
Viewing 15 posts - 6,511 through 6,525 (of 39,776 total)