Rudyx - the Doctor (7/26/2016)

---

declare @CoverUp varchar(16)

select @CoverUp = ['True'|'False'] --> make your choice

if CoverUp = 'True'

...

Post what you have tried and the errors

😎

Piling on, sp_Blitz is good but one must thoroughly validate all settings and configurations on the servers in such a situation. Far too often have I seen simple mistakes like...

The calculation is quite simple, divide the number by 1000 to get the year and the add the remainder of the division - 1 as days, here is a quick...

Quick question, you have TF-1118, why not also TRACE FLAG 1117 – equal growth of files in a filegroup?

😎

Piling on, nmap network scanner[/url] will do nicely discovering any services on a network including SQL Server instances

😎

Sean Lange (7/26/2016)

---

Jack Corbett (7/26/2016)

---

Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current...

Best practice is to set the database in a single user mode when changing the compatibility level to prevent cross level compilation and incorrect / bad plans being cached. Changing...

Piling on, the demonstrated expected output does not fit the description, can you please clarify?

😎

Quick suggestion, post the actual execution plan and the full specs of the server

😎

Piling on, one of the fastest ways of doing this is to use Window Function with the appropriate POC index

😎

IF OBJECT_ID('tempdb..#tab1', 'U') IS NOT NULL

DROP TABLE #tab1;

CREATE...

This should be fine but preferably no activity should take place in the databases during the upgrade.

😎

Quick question, are you specifying either -c character type or -w wide character type

😎

Quick question, what is the output data type?

😎

This task is trivial and a simple conversion to SMALLDATETIME should do the trick

DECLARE @DT DATETIME = GETDATE();

SELECT

@DT

...

naren.ece2012 (7/6/2016)

---

Dear Experts,

We are getting error while taking backup of a database on local Drive( Operating system error 1117 (The request can not be performed because of I\O device error)).

Details

SQL...