Jul
2
awarded  Yearling
Feb
26
awarded  Popular Question
Jan
11
answered Azure sql database grant select on certain tables
2018
Nov
6
comment full model backup with tran logs
Hi Gabriele, It depends, have you tried shrinking the file and has it grown back again? What maintenance tasks have you got running? Was there a time when you did not have any logbackups running? What is the size of your biggest Index?
Aug
29
comment Using sp_send_dbmail with SQL authentication to send attachments from UNC path
What account did you define in your profile?
Aug
3
comment 1000's of SQL Update Statements taking forever to complete
Try doing smaller batches & check the waits on the query when they are executing. Are you hitting the right indexes etc. Can you give me the plan of this query?
Aug
3
comment 1000's of SQL Update Statements taking forever to complete
can you make smaller batches?
Aug
3
comment 1000's of SQL Update Statements taking forever to complete
Are you doing them one by one (RBAR) or are you doing this 1000 at a time?
Jul
31
revised SQL Server 2016, temporal tables and compressed indexes
added 17 characters in body
Jul
31
revised Microsoft SQL Server error 14545
added 26 characters in body
Jul
31
answered SQL Server 2016, temporal tables and compressed indexes
Jul
31
revised Microsoft SQL Server error 14545
added 637 characters in body
Jul
31
comment Microsoft SQL Server error 14545
Ok let me edit the answer
Jul
31
comment Microsoft SQL Server error 14545
Do the databases exist on the other two servers? Does the data have to kept in sync afterwarts, or is just the db copy enough?
Jul
31
comment Microsoft SQL Server error 14545
You need to do this on a regular basis? Or just the one time?
Jul
31
answered Microsoft SQL Server error 14545
Jul
31
comment Microsoft SQL Server error 14545
Do you want to move your database? or just have a copy at the other server?
Jul
26
comment Find the customers who bought at least the products bought by customer with “name 4”
I thought you did not want to display customer 'name 4' if you want to display it, you can remove the and c.Name <> 'Name 4' at the end and it will display 'Name 4' as well
Jul
26
answered job send email to developers upon complexion and include DBAs if it fails
Jul
26
comment Rebuild Index Causing Data File Growth Issue
What version of sql server & which edition?