sqlguy-736318 (12/5/2016)

---

I created a console app in .NET to call a sproc 25 times concurrently. Max return time was 999ms, min was 20ms and avg was 565ms.

Then I exec'd...

Quick question, why are you using float?

😎

The value returned is exactly the same, but in scientific notation. You can change the last parameter of the Convert function which will...

rodjkidd (12/5/2016)

---

Eirikur and Chris,

I'm in London all week, and free lunch times. Although today I'm waiting for the Royal Albert Hall booking line to open...

So let me know when you...

BOR15K (12/5/2016)

---

I have a table of several millions of records for flight ticket. One of the indices is Flight Ticket, so when user searches for ticket 1234567 or 123456% all...

Tatay_2016 (11/25/2016)

---

Hi,

First time here. I'm the admin of a small business with a mssql database that is remotely hosted by our website provider. I need to import/export...

ScottPletcher (12/2/2016)

---

Personally I've had much lesser delays/stalls using this command:

ALTER DATABASE SQLTRIX SET OFFLINE WITH ROLLBACK_IMMEDIATE;

And you can get into devilish issues with "SINGLE_USER". You need to make sure...

The DBCC TRACESTATUS lists out active trace flags, has nothing to do with traces....

Thank you for this write up Kenneth.

😎

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(SD_ID,SD_TEXT) AS

(

SELECT 1,'AA' UNION ALL

SELECT 2,'BB' UNION ALL

SELECT 3,'CC'

)

SELECT

...

And the output?

😎

Andrew P (11/29/2016)

---

I've identified one of our databases has significant corruption, including several extent allocation issues and SGAM allocation issues.

After doing some research on this, I'm aware I can identify...

Mike Scalise (11/29/2016)

---

Hi,

Has anyone been able to successfully use Ola Hallengren's maintenance scripts to only clean up old backups and not take a new backup? I have full backups running...

Here is a quick solution that should get you passed this hurdle

😎

Note that it is around 4 times more efficient than the code you posted

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @TXML TABLE...

rodjkidd (11/29/2016)

---

Eirikur Eiriksson (11/24/2016)

---

Gazareth (11/24/2016)

---

Eirikur Eiriksson (11/24/2016)

---

Gazareth (11/24/2016)

---

BWFC (11/24/2016)

---

ThomasRushton (11/24/2016)

---

BLOB EATER (11/24/2016)

---

GilaMonster (11/24/2016)

---

The office kitchen also caters to stranger tastes, with 3...

HappyGeek (11/29/2016)

---

Many thanks for the prompt responses, but just to clarify:

I am looking at tempdb, it has 8 data files plus the log. the mdf file has initial size of...