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...

Paul Giles-Randall (7/25/2016)

---

Firstly, this is a system that I have inherited.

I have a cursor that pulls out a set of ids and amounts. The data is as follows:

ID ...

The structure was last changed in SQL Server 2005...

sharonsql2013 (7/25/2016)

---

Hi ,

I am trying to plot map in Reporting tool. I see that we need spatial data in SQL.

All our SQL table has is Country , City and Region....

Nothing unusual as such, PLE is only one of the memory related counters and there can be many reasons for it to drop on an sparse memory resource instance like...