Quick thought, it might be easier to query the sys.partitions for the row count

😎

;WITH LIST_TABLE AS

(

SELECT

T.object_id

...

Just got an "interesting" email via SSC, Steve are you expanding the "service"?

😎

tim_harkin (10/28/2014)

---

Solved it myself. When I looked at 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\setup.exe' the file size was 0 KB. I renamed that to setup.exe.old, and re-ran the installer...

Jeff Moden (11/7/2014)

---

qinzhen (11/7/2014)

---

Eirikur Eiriksson (11/6/2014)

---

There are several ways of doing this, somewhat depends on the circumstances which fits best.

Quick questions:

1) Does each file have a single format (number of...

ufrufr (11/7/2014)

---

Eirikur Eiriksson (11/6/2014)

---

Quick thoughts, first is that the non-clustered index is not a covering index and will require an additional key lookup to satisfy the query output. Therefore the...

niladri.primalink (11/6/2014)

---

Hi All,

Hope you are doing great. I want to know one thing. I have idea on SMK, DMK and symmetric and asymmetric keys. I have also idea on TDE....

Quick thoughts, first is that the non-clustered index is not a covering index and will require an additional key lookup to satisfy the query output. Therefore the server simply deems...

SQL DBA-909494 (11/6/2014)

---

Hi,

I am looking for a script which will help me to capture the object details like constraints, clustered & non-clustered indexes, primary & foreign keys, etc before migration...

qinzhen (11/6/2014)

---

hi.

I have a lot of txt files with data that I need to import. They are "|" separated data files.

Some of them have the columns like...

Yes, stay away from the red one:-D

So here's a question...

Let's say...

occasional sql (11/6/2014)

---

I want to be able to return the rows from a table that have been updated since a specific time. My query returns results in less than 1...

ramana3327 (11/6/2014)

---

The reports are taking long time. Once I restart the server, the report time come down. The report is using the default parameters for the sp. After the restart...

Quick question, are you using Remote BLOB Storage (RBS)?

😎

Just for fun, a computed column solution:-)

😎

USE tempdb;

GO

SET NOCOUNT ON;

CREATE TABLE dbo.TBL_COUNT_TO_THREE

(

CTT_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_DBO_TBL_COUNT_TO_THREE_CTT_ID PRIMARY KEY CLUSTERED

,CTT_VAL VARCHAR(50)...

harrietf (11/6/2014)

---

When I look at the C drive properties of this server, which is used only as a Sharepoint - Intranet server, it appears as if 85% of the drive...