aarded (11/21/2011)

---

OK...

It was just an example. Please don't just follow it, try to understand it. You are missing on Server Level permissions.

BTW Did you follow Markus advice? It should work for...

aarded (11/21/2011)

---

Dev (11/21/2011)

---

Change you SP to execute it in Login's Context...

EXECUTE AS LOGIN = 'DMView'; -- Context Switch

SELECT physical_io FROM master..sysprocesses WITH (NOLOCK) WHERE spid = @@SPID

SELECT cntr_value...

Change you SP to execute it in Login's Context...

EXECUTE AS LOGIN = 'DMView'; -- Context Switch

SELECT physical_io FROM master..sysprocesses WITH (NOLOCK) WHERE spid = @@SPID

SELECT cntr_value FROM master.sys.dm_os_performance_counters

'VIEW SERVER STATE' is a permission given to login.

GRANT permission [ ,...n ]

TO <grantee_principal> [ ,...n ] [ WITH GRANT OPTION ]

...

I wish my company believe in this policy / thoughts. 😀

jp.sqldba (11/21/2011)

---

hi dude, check it u r entering password correctly and also check the following

Error: 18456, Severity: 14, State: 8.

Base on the Error state u can identify the error...

Thanks opc.three & Jeff for your thoughts.

I would like to clarify few things on my end.

•By saying that “Space is Cheap” I never meant that we can misuse the Disk...

The actual discussion started here & the thumb rule here is NOT to use ORDER BY.

Last 5 rows

http://www.sqlservercentral.com/Forums/Topic1206622-391-1.aspx

Planning a SQL Server Installation

http://msdn.microsoft.com/en-us/library/bb500442.aspx

How to: Install SQL Server 2008 R2 (Setup)

http://msdn.microsoft.com/en-us/library/ms143219.aspx

How to: Upgrade to SQL Server 2008 R2 (Setup)

http://msdn.microsoft.com/en-us/library/ms144267.aspx

I believe your database structure is like this.

CREATE TABLE GF

(

GF_ID INT, -- PK

DATA VARCHAR(100)

);

CREATE TABLE F

(

GF_ID INT, -- COMPOSITE PK, FK

F_ID INT, -- COMPOSITE PK

DATA VARCHAR(100)

);

CREATE TABLE C

(

GF_ID INT, --...

GilaMonster (11/19/2011)

---

Sparse columns (requires SQL 2008)

Thing is, all the columns must be nullable and it's intended for columns that are mostly (90%+) NULL

I'm not going to write out 1000+ columns,...

Having a "tall skinny" (NVP or Name Value Pair) table, like what you're suggesting, would actually more than triple the storage space required because, not only must you store the...

Agree with you Perry 😀

Agree with Gail but let’s see if we can attempt it.

$queryL = $select.$from.$where.$order;

Based on your code (specifically above line) I believe you are building query at runtime (Dynamic SQL). Can...