I append row counts to a table every night with a procedure that uses the following code (which I got from here):

SELECT o.nameas [TableName]

,i.rowsas [RowCount]

FROM sysobjects o

INNER JOIN sysindexes...

I noticed the other day (which may or may not be relevant) that (things like column descriptions) added in the the table designer are added as an extended property with...

Am I (and Google "define") the only ones who don't know the definition of "colleagures"?

Google finds references, but not definitions.

I assume that knowing that ought to give you...

RE:"Nominate yourself, no points off for that if you think you're an exceptional DBA."

As I have admitted in other posts, I'm not a real DBA, I just play one at...

I wonder if others are going to find it difficult to nominate other DBAs because they don't typically get to see many other DBAs in a work environment. Based on...

I much prefer treating this requirement as a pull rather than a push. Make each query into a view, and give your user(s) select access to the view.

Then create a...

Thanks.

You might want to do something to avoid also listing references to tables that include the target name with a prefix or suffix; e.g. 'MyTable' will also return...

I was disappointed when, per the MS Connect site, that the horrible flaw in the SSIS FTP task was not fixed. (The flaw is that the source/destination directory is arbitrarily...

You deserve at least a dozen ataboys!

OK, I am reacting to the title(!), although a brief read seems to confirm your insights, and I promise to read the whole thing...

Thanks Hans! I guess I'll need to play with that and (yet again) try to educate myself.

Toni - Until you pointed out that QUERY_GOVERNOR_COST_LIMIT had to be set in the query, it had not occurred to me. If the new Resource Governor falls into the...

In VBA, the CurrentRegion property of a range can be used to find the limits of an area containing data, as defined by blank rows/columns surrounding the data area.

So...

There is a danger in assuming that the database engine will simply do what we simplistic users fear we would have to do if we were processing the query. Remember...

Tomm Carr (4/22/2008)

---

I don't know why you just couldn't use:

select * from dbo.function1( '2007-12-01', '2007-12-31' )

instead of wrapping the function (itself a wrapper) inside a view.

Your problem is that there...

The response I liked best was from Matt, and later Oberion.

My initial question suffered from a lack of full disclosure:

My current DB is for query only (OLAP if you like,...