Reputation
1,459
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
9 25
Newest
 Constituent
Impact
~104k people reached

Aug
12
comment What are the default fixed server role members for SQL Server 2012
"CANUCK\" bwahahaha
Aug
10
awarded  Constituent
Jul
28
awarded  Caucus
Jul
25
awarded  Yearling
Jul
23
comment How to Interpret Trace Flag 1222 deadlock
@sebeid maybe you should read the articles included in the link. They will probably explain how you are getting this deadlock. Although I will warn that deadlock troubleshooting can be quite tricky.
Jul
10
comment SQL Join Field and Content
I'm going to have to agree with @dezso here and would like you to add maybe an example of what you have so far. Anything you could add to make it so we can understand enough to help you.
Jul
9
comment Searching SSIS packages for the use of specific tables
You can also use a text crawler or a Powershell Script to comb through your source control directory.
Jun
26
awarded  Custodian
Jun
23
accepted Predicate not resulting in expected scan
Jun
23
comment Predicate not resulting in expected scan
@MartinSmith indeed it does.
Jun
23
comment Predicate not resulting in expected scan
@MartinSmith that's it!
Jun
23
comment Predicate not resulting in expected scan
If my recolection serves me correctly GETDATE() functions are calculated prior to runtime and therefore this does not apply. Also it is used in the first query and the Image date is used in that one.
Jun
23
asked Predicate not resulting in expected scan
Jun
16
revised How to pass parameter in select query(In with clause) and not in where condition in SQl Server SSIS Package?
added 1 character in body
Jun
16
answered How to pass parameter in select query(In with clause) and not in where condition in SQl Server SSIS Package?
Jun
16
comment Optimization issue with user defined function
@JamesZ it sound like you've got a developer to strangle.
Jun
3
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
@JimThio the idea that you're just going to pop over to MongoDB from MySQL leads me to beleive you might need to look into Mongo a little further.
May
29
comment SQL Server Agent Job, Access Denied
Can you clearify what you mean here "I have a T-SQL agent job that I've created that adds steps to itself depending on a query of the MSDB database." ?????
May
29
answered How can I determine which tables are causing the database to grow over time?
May
22
comment LDF files vs. TRN files vs. Tempdb.MDF+LDF files.:
I think we could probably get the just of this without your IP address.