Viewing 15 posts - 91 through 105 (of 2,458 total)
October 3, 2018 at 11:53 am
October 3, 2018 at 11:52 am
Steve Jones - SSC Editor - Wednesday, September 26, 2018 2:35 PMI am praying for this: https://www.mlb.com/news/how-nl-contenders-could-end-season-in-a-tie/c-295843618
Be careful what you...
October 1, 2018 at 6:09 am
September 14, 2018 at 10:31 am
September 12, 2018 at 1:03 pm
In addition to what everyone else said -
it's worth noting that T-SQL scalar user defined functions (UDF) are generally horrible and cause all kinds of problems even when...
September 12, 2018 at 12:04 pm
One thing you could try (but this is a little advanced and would require a little reading) is to use an XML Transform to generate a word document. Note
September 11, 2018 at 11:31 am
Great question - I think this is a good topic that isn't talked about enough.
Per Books Online:
"While the default value of 5 is retained for backwards...
September 11, 2018 at 8:57 am
Just read through this. Very good stuff. I've unwillingly become a part-time accidental DBA at work and deal with a my share of failing SQL instances. This will be good...
September 11, 2018 at 7:35 am
Unless it's someone in my field I say "computer stuff". Anything beyond that I generally get a blank stare.
July 30, 2018 at 12:41 pm
July 17, 2018 at 1:52 pm
pietlinden beat me to it - here's what that solution would look like:
-- Sample data
USE tempdb
GO
IF OBJECT_ID('dbo.t1') IS NOT NULL DROP TABLE dbo.t1;
July 11, 2018 at 3:40 pm
I'm stuck on the last Sunday at the moment but here's how you handle the first Monday.
Lynn Pettis has a great post about common date routines. I...
June 20, 2018 at 10:09 pm
Viewing 15 posts - 91 through 105 (of 2,458 total)