Shrinks SUCK!!! They will no matter what you try to do - unless you can do a truncate_only shrink and get back the space you need, but how often...

saikat.pan (6/5/2014)

---

We have a Silverlight based application which currently supports only one production version. Idea is to support three concurrent versions of the same application and user will switch to...

Robert Davis (6/5/2014)

---

Are they going to create newer versions of their log tool? I read that it won't be updated for SQL 2012 or 2014 because MSFT is no longer...

I recommend using ApexSQL's transaction log centric tools. Pretty amazing what they can do as far as redo/undo from tlog activity!! They don't have any competitor that I...

george sibbald (6/5/2014)

---

I have an app where the vendor recommends (nay insists) setting maxdop to 1 and cost threshold to 15, go figure.........

Is Dynamics AX a microsoft product, they have...

It really...

Do you have ALL of the things in that KB in your systems? Also note that the workaround is to use a LOCAL ACCOUNT when installing. Then you...

SQLRNNR (6/4/2014)

---

TheSQLGuru (6/3/2014)

---

Jeff Moden (6/3/2014)

---

Just a caution... if the view code uses scalar or multi-statement table value function, you really shouldn't be using SET STATISTICS as a measuring tool because...

What is the growth factor for the data file(s)? What is the size of the indexes that are still fragmented?

ApexSQL has a product that allows you to see tlog activity in detail and even create replay/undo scripts from it. Very slick stuff that has helped a number of...

Jeff Moden (6/3/2014)

---

Just a caution... if the view code uses scalar or multi-statement table value function, you really shouldn't be using SET STATISTICS as a measuring tool because it skews...

In my experience, the most common cause for what you are seeing is that you are not on Enterprise Edition of SQL Server.

If you are, see Books Online...

Yeah - that was the main point included in the distraction plea, although not the only one!! :hehe:

I call "daughter distraction" on that one Lynn! 🙂 Actually I have seen, and used myself often, int dates stored as CCYYMMDD in data warehouses. I think a...

CREATE TABLE XXXX_XX(

[DM_CV_AGGR_FACT_POLICY_COVERAGE_ID] [int] IDENTITY(1,1) NOT NULL,

[POL_TYPE_ID] [int] NULL,

[GENDER] [varchar](1) NULL,

[DRIVER_AGE_RANGE_ID] [int] NULL,

[CARRIER_ID] [varchar](11) NULL,

[C_ST_ALPH] [nvarchar](10) NULL,

[LIMIT_ID] [int] NULL,

[BIZ_MONTHYEAR] [int] NOT NULL,

[BIZ_YEAR] [varchar](4) NULL,

[BIZ_MONTH] [varchar](2) NULL,

[TOT_POLICY_COUNT] [int] NULL,

[TOT_VEHICLE_COUNT] [int] NULL,

[TOT_DRIVER_COUNT]...