82 reputation
18
bio website
location Atlanta, GA
age
visits member for 2 years, 3 months
seen Jun 3 at 20:43

Jul
2
awarded  Curious
Jan
8
awarded  Popular Question
Nov
20
awarded  Notable Question
Oct
2
revised Geography union via cursor returning null
added 907 characters in body
Oct
2
accepted Geography union via cursor returning null
Oct
2
comment Geography union via cursor returning null
You're entirely correct, I didn't even notice that. Worked fine when I initialized @ShapeUnion before the loop.
Oct
2
asked Geography union via cursor returning null
Apr
6
awarded  Popular Question
Mar
8
comment Creating indexes with t-sql scrips vs rebuild indexes in maintenance plan
From my experience, depending on the scope of the operations being done in the script and the size of the data sets, it may be beneficial to generate one set of indexes for the insert/update process and then drop those and generate another set of indexes for use in querying. I would suggest playing around with different configurations and study the query plans generated in each setup until you find one that maximizes efficiency.
Jan
25
accepted Is there a way to get instance_id from msdb.dbo.sysjobhistory during the execution of a SQL Job step?
Jan
24
awarded  Commentator
Jan
24
comment Is there a way to get instance_id from msdb.dbo.sysjobhistory during the execution of a SQL Job step?
@Marian Thanks, I'm not sure what happened to the rest of it when I submitted it. As for tokens, I can't see how that would be possible to do during the execution of the SSIS package since the instance_id record does not exist in the table. Whether it exists somewhere else at that point as a token, I do not know.
Jan
24
revised Is there a way to get instance_id from msdb.dbo.sysjobhistory during the execution of a SQL Job step?
added 191 characters in body
Jan
24
comment Is there a way to get instance_id from msdb.dbo.sysjobhistory during the execution of a SQL Job step?
I was planning to create my own table, I want to create a one-to-many relationship between sysjobhistory and my table (let's call it TaskLog) with instance_id. The problem is that instance_id is generated after the step is complete.
Jan
24
asked Is there a way to get instance_id from msdb.dbo.sysjobhistory during the execution of a SQL Job step?
Dec
17
comment Requesting advice on creating a table controlled SQL job scheduler
@AaronBertrand There are new alerts being added on a fairly regular basis and, since there is no real control structure, the entire company is being inundated with alerts every time they run. The ultimate goal is to make it so that each alert only goes out to certain people and the recepients can be easily adjusted in a table. I assumed that an uber-job would be the best route to take in order to accomplish this.
Dec
17
asked Requesting advice on creating a table controlled SQL job scheduler
Oct
26
awarded  Scholar
Oct
26
comment I want to perform multiple date adds on a date range and select those individual dates
Works like a dream. Thanks for your help.
Oct
26
accepted I want to perform multiple date adds on a date range and select those individual dates