Viewing 15 posts - 1,276 through 1,290 (of 7,191 total)
DROP TABLE #Results
CREATE TABLE #Results (
SchemaName sysname NOT NULL
, DBName sysname NOT NULL
, TableName sysname NOT NULL
, IndexName sysname NULL
, Frag decimal NOT NULL
September 19, 2017 at 2:15 am
Yes, you probably do need something a bit more sophisticated than just a calendar table. The snippet below will convert your Dates table into a table that just shows the...
August 25, 2017 at 9:22 am
Create a calendar table in your database, with weekends and other non-working days marked off. You then only need to add another predicate to your WHERE clause:WHERE...
August 25, 2017 at 6:55 am
I would just restore the databases from where the backups are. You may need to tweak some NTFS permissions, and maybe change some drive letters to UNCs, but it'll cut...
August 25, 2017 at 4:46 am
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
Viewing 15 posts - 1,276 through 1,290 (of 7,191 total)