126 reputation
3
bio website
location Missouri
age 31
visits member for 3 years, 3 months
seen Jan 21 at 15:43

A follower of Christ, bookworm, outdoorsman, musician. Please see my Area 51 proposal for a Microsoft CRM site: http://area51.stackexchange.com/proposals/32455/microsoft-crm


Sep
24
awarded  Autobiographer
May
23
awarded  Supporter
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.
May
23
asked How can I run a T-SQL Script using SQL Credentials?
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.
Jun
22
awarded  Student
Jun
22
asked Why did my UPDATE statement not complete?