Viewing 15 posts - 12,226 through 12,240 (of 59,064 total)
While I absolutely agree that PowerShell is powerful, Cmd.Exe is not deprecated and isn't likely to ever be. Neither is xp_CmdShell.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-cmdshell-transact-sql?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2016?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2017?view=sql-server-2017
May 22, 2018 at 9:00 pm
May 22, 2018 at 4:14 pm
May 22, 2018 at 4:11 pm
how about:
CREATE PROCEDURE IsJobRunning @JobName as varchar(100) = Null as
--check!!
if (@JobName IS NULL) RETURN -1
Declare @theID as...
May 22, 2018 at 3:26 pm
Sounds like a lot of work and problems with MERGE have and (apparently) continue with it. I just do good ol' fashioned "Upserts" and call the job done.
May 22, 2018 at 10:05 am
May 22, 2018 at 10:02 am
Also, INTERSECT matches on NULL = NULL whereas Joins usually do not (default server setting).
May 22, 2018 at 10:00 am
Yesterday I replied (with incorrect information) to a...
May 22, 2018 at 9:46 am
I just hit it with a dynamic CROSSTAB (and not PIVOT, which is usually twice as slow) and have SSRS call the stored procedure.
May 22, 2018 at 9:42 am
May 22, 2018 at 9:27 am
First, protect yourself for the future because this won't be the last time you run into such a thing. STOP putting 3 and 4 part naming into your code. Instead,...
May 22, 2018 at 9:19 am
Heh... guess I'll have no need for Python, either, then. I do the dynamic pivoting all in T-SQL, as well. 😀
May 22, 2018 at 7:30 am
I have been stuck on this for a long time now, I hope that someone...
May 22, 2018 at 5:46 am
Viewing 15 posts - 12,226 through 12,240 (of 59,064 total)