Viewing 15 posts - 841 through 855 (of 7,187 total)
March 9, 2018 at 2:56 am
There are circumstances under which the server will need to be rebooted. As part of the installation wizard, you are invited to close any processes that would otherwise cause the...
March 9, 2018 at 2:11 am
March 8, 2018 at 7:37 am
This may work, although I don't understand why the date for AB22 shouldn't be 2017-02-09?
WITH MaxDates AS (
SELECT
STAT_CODE
, DATE
, PART_NO
March 8, 2018 at 5:03 am
Ditch the attitude when you're asking for help, please. (I've never referred to myself as a "guru" - it's just a forum classification.)
No, I haven't faced this situation. ...
March 8, 2018 at 4:46 am
There have been studies that show the change doesn't help with power, and it's certainly disruptive to everyone.
I'm not so...
March 8, 2018 at 4:31 am
March 8, 2018 at 4:13 am
. I tried Generate Scripts method but it is unable to script...
March 8, 2018 at 4:02 am
Is there a sql query that I can run that will give the same detail...
March 8, 2018 at 3:28 am
You need to do a left join so that you get all of the rows from StartPoints. You'll get a NULL on the right hand side, but you can handle...
March 6, 2018 at 8:53 am
Sounds like you have a lot of unused indexes, yes. But you need to consider how long it is since the DMVs were reset (usually the last time SQL Server...
March 5, 2018 at 8:39 am
what I'm not clear about is when to completely remove a particular...
March 5, 2018 at 8:22 am
Number the rows in the StartPoint CTE using ROW_NUMBER(). Then, instead of using LEAD in the StartPointsandNext CTE, join StartPoint to itself on RowNo = RowNo + 1.
John
March 5, 2018 at 7:39 am
DECLARE @Contents varchar(4000)
SET @Contents =
'abcdef 01/01/2018 08:15:13 This is a note , this is a note , this is a note , this is a...
March 5, 2018 at 7:09 am
Viewing 15 posts - 841 through 855 (of 7,187 total)