SQL Learner - VKG (12/7/2016)

---

Hello Guys,

I a table of around 10 GB size. Recovery model of database (SQL Server 2005) is simple. For some requirement, I added a clustered index...

You have to begin a transaction

BEGIN TRANSACTION

...

COMMIT/ROLLBACK

Find this reference useful - https://msdn.microsoft.com/en-us/library/ms188929.aspx

Did you run in the database context? The query runs at my servers.

whenriksen (12/5/2016)

---

DDL & DML would help.

First of all, you've created a temp table #LocalizedCategories, but you are doing a Select Distinct on it. Is there any reason you couldn't...

RAND() is also a T-SQL function.

https://msdn.microsoft.com/en-us/library/ms177610.aspx

Ed Wagner (12/3/2016)

---

Jeff Moden (12/3/2016)

---

TheSQLGuru (12/3/2016)

---

I have to take exception with one thing you said Igor:

EF, as in Entity...

I'm following the discussion from its start.

The performance related with the hardware and the server configuration is not the big problem after you get the matters settled on. Adding faster...

Sometimes this kind of theoretical questions are good to put in a change to QotDs. Thanks.

sandy-833685 (12/1/2016)

---

AlertsSize Bytes Per Row

dbo.IRST6553.6

dbo.Ulog5461.33333

dbo.VAE8192

dbo.IRR8192

dbo.Rdata8192

dbo.InfoData81920

dbo.IRTrans49152

dbo.IRC16384

dbo.Transactions65536

dbo.ARPin16384

dbo.IRRPT32768

Total Bytes298734.9333

Above is the details size in bytes for per transactions which and total size comes approx - 300 KB, Yes Every table has clustered and...

First, is your calculation exact? You should re-check it, or correct me if I'm wrong.

300 KB of data for one transaction (with referencing data in 7 other tables) is too...

GilaMonster (11/29/2016)

---

Long term plan, see if you can upgrade both to something modern, like SQL 2016. 2008 R2 is already out of support, 2012 will be out of support in...

trhorner (11/29/2016)

---

I am putting together a "recovery" plan if hardware fails, and since the business allows 120 minute recovery window,

I plan to do full and log backup restores of...

msimone (11/28/2016)

---

Hello Igor, I believe that I had a mistake in the previous post for to explain my doubt.

My question is the difference between to put "LISTENER_IP = ALL" or...

msimone (11/17/2016)

---

Hello.

I have a doubt.

I don't exactly know how the option LISTENER_IP works to create an endpoint for service broker.

Does the instance hear the IP setting in the endpoint...

Ed Wagner (11/28/2016)

---

djj (11/28/2016)

---

Ed Wagner (11/26/2016)

---

DamianC (11/26/2016)

---

Ed Wagner (11/26/2016)

---

TomThomson (11/24/2016)

---

Pacane (Spelling corrected; if you...