Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.

😎

drew.allen (8/14/2015)

---

First,...

Chris.Hubbard4U (8/14/2015)

---

I queried that table but...

Fast food

Quick alteration to Lynn's good solution, handles values both higher and lower than the target value

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_TEST_SET_20150814001') IS NOT NULL DROP TABLE dbo.TBL_TEST_SET_20150814001;

CREATE TABLE dbo.TBL_TEST_SET_20150814001

(

...

Alvin Ramard (8/14/2015)

---

Lynn Pettis (8/14/2015)

---

Something like this:

declare @TestTable table(

EEID int,

Name varchar(64),

AnnualizingFactor int,

PercentFullTime decimal(3,2));

insert into...

Endangered

Further on Chris's reply, this is a high level representation of what goes on behind the scene when a query is executed, it can be good, bad or ugly but...

Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'

😎

Luis Cazares (8/14/2015)

---

Ed Wagner (8/14/2015)

---

crookj (8/14/2015)

---

BL0B_EATER (8/14/2015)

---

Ed Wagner (8/14/2015)

---

SQLRNNR (8/13/2015)

---

Ed Wagner (8/13/2015)

---

DonlSimpson (8/12/2015)

---

SQLRNNR (8/12/2015)

---

Luis Cazares (8/12/2015)

---

WayneS (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Ed Wagner (8/12/2015)

---

SQLRNNR (8/12/2015)

---

whereisSQL? (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Eirikur Eiriksson (8/12/2015)

---

Ed Wagner (8/12/2015)

---

Steve Jones...

kevin.ellis86 (8/14/2015)

---

These results look like how to create the tables which I don't need help with. Suppose these two tables had no relationship between them built yet and I wanted...

drew.allen (8/14/2015)

---

Alan.B (8/13/2015)

---

drew.allen (8/13/2015)

---

Alan.B (8/13/2015)

---

Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the...

odeddror (8/14/2015)

---

All I want is to count actual column count per all tables (and schema too)

row count is sometime can be misleading (nulls, 0's or ' ' spaces)

Your sproc...

He he, if I had a penny for every mis-spelling of my name...

Here is a simple profiling procedure I've used for years, nothing fancy but often quite helpful.

😎

NOTE: By the nature of the profiling, it can and will place considerable stress on...