Viewing 15 posts - 1,276 through 1,290 (of 7,187 total)
If you're intepreting NULL as 0, then:
SELECT COALESCE(col1,0) + COALESCE(col2,0) + ... AS SumofAllCols
FROM MyTable
(You can also use ISNULL instead of COALESCE. It's...
August 25, 2017 at 4:24 am
Paul
Do you already have something set up that goes to all servers and gathers information about the most recent backup of each database? If not, that would be...
August 25, 2017 at 4:14 am
Yes, and if you do update the table so that there are no more NULLs, make sure you also update the table DDL so that all columns are defined as...
August 25, 2017 at 3:53 am
I suspect that you don't need that UNION ALL. Indeed, you might not need to stage in @TempTable at all. If you post table DDL (CREATE TABLE statements) and sample...
August 24, 2017 at 2:40 am
session_id host_name program_name client_interface_name login_name session_status database_name request_status command wait_type wait_sec last_wait_type wait_resource blocking_session_id blocking_host blocking_program blocking_login transaction_id open_transaction_count cpu_sec total_elapsed_sec start_time reads writes logical_reads isol_level object_name sql_handle plan_handle text
51 MSCSMCY-SHIPMAT Microsoft SQL Server Management Studio...
August 23, 2017 at 9:05 am
August 23, 2017 at 4:18 am
Yes, as others have said, you need to change the passwords in SSCM. If you don't do that, the services will continue to run normally until the next time they...
August 23, 2017 at 2:38 am
I think there is something to understand if it's failing, yes. My point is that you might not want to put too much effort into doing so given that you...
August 23, 2017 at 2:27 am
gtrennert - Wednesday, August 23, 2017 2:07 AMyes they execute without any problem
Gosh, yes, you did say that in your original post....
August 23, 2017 at 2:10 am
Have you tried running those 51408 statements (or some of them) manually?
John
August 23, 2017 at 2:04 am
What is your question? Remember we can't see your screen and we don't know anything about your data. We'll need the actual execution plan as a minimum here to help...
August 22, 2017 at 2:33 am
That's not the full output of that query. And did you run it while the index creation statement was running?
John
August 22, 2017 at 2:09 am
It does appear I do not have permissions to create a view. So your saying the...
August 22, 2017 at 2:04 am
What is the wait type for the SPID that's attempting to create the index?
John
August 21, 2017 at 9:58 am
Viewing 15 posts - 1,276 through 1,290 (of 7,187 total)