Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
4
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
May
23
comment How can I run a T-SQL Script using SQL Credentials?
That makes perfect sense. Would I be able to authenticate as a SQL user using that method? I would use the authenticated Windows user but I have them set, in the database, with read-only access for security reasons. SA is what I would like to use.
Jun
24
comment Why did my UPDATE statement not complete?
The rows are not deleted by this update statement. Only one field for each row is updated.
Jun
24
comment Why did my UPDATE statement not complete?
The clustered index update, for the primary key, takes up a majority of the query cost at 65%. The other heavy hitters are 2 Table Spool (Eager Spool) at 24%
Jun
22
comment Why did my UPDATE statement not complete?
I have non-clustered indexes on the columns in the first update query that I tried to update 1 row from. I re-built all of the indexes but no change in execution.