Viewing 15 posts - 2,281 through 2,295 (of 7,504 total)
Always good to post the thing you tried.
You must tell sql what you want.
You want per date usernames and the number of logins.
So this is the kind of query you...
February 26, 2011 at 10:59 am
GilaMonster (2/25/2011)
ALZDBA (2/25/2011)
It states the magical figure of 100 rows.Does it also state where that 'magical' figure comes from?
Nope.
Page 24 mentions the estimated rowcount 0 or 1 for @tv...
February 26, 2011 at 1:17 am
Do you want to return all last names in a single return field or do you want to return a set of all last names ( row based ) ??
If...
February 26, 2011 at 1:06 am
search Books Online on "GROUP BY clause, AVG function".
You'll find nice examples of what you need.
February 26, 2011 at 12:56 am
I'm not going into details on this one. It's been couvered totally already.
RBarry, it is ok to refer to your series of article on how to lose the cursors and...
February 26, 2011 at 12:46 am
must be homework :ermm:
just select the columns you need and add a count(*) as nLogins
Convert your datetime column so the startime is converted to 00:00:00.000
( or convert it to date...
February 26, 2011 at 12:32 am
there is also a free downloadable ebook at red-gate called "sql server statistics". It states the magical figure of 100 rows.
It also has some statements on the differences of @...
February 25, 2011 at 2:22 pm
Steve.hitch (2/25/2011)....
Unfortunately, the way this data is arranged doen't allow for unique keys. The data captures project data for employee by date. The payroll system will allow multiple entries for...
February 25, 2011 at 1:41 pm
indeed, a udf needs to be addressed schema qualified.
select yourschema.yourudf( paramcol )
from yourobject
....
February 25, 2011 at 11:29 am
So, on this logging table, how do you identify a single row ?
If you cannot: Is this worth a concern for your data system ?
If that is a concern, one...
February 25, 2011 at 11:26 am
strange a monitoring company doesn't manage their db and db logs.
Please read the article Gail pointed to. It will clarify our concerns.
In many cases, people think they don't need PIT...
February 25, 2011 at 11:17 am
Roy Ernest (2/25/2011)
Feeling much better, Thanks. It is difficult to keep with the THREAD if you dont read the THREAD for just couple of hrs. 😀
Maybe we should ask OP...
February 25, 2011 at 8:31 am
If to you NULL = '' then declare you column NOT NULL !! (maybe even add "with default '' )
there are some nice article regarding NULL and its impact...
February 25, 2011 at 5:24 am
Just make sure you include the catalog name ( i.e. dbname) in your joins.
Of course only pick the columns you need. (c.* :ermm: )
--sp_pkey
SELECT kcu.COLUMN_NAME
...
February 24, 2011 at 1:49 pm
If I'm correct you need middleware for SQL2005.
With SQL2008 MS did aquire that middleware.
Now, if only I could recall the exact name.
February 24, 2011 at 1:31 pm
Viewing 15 posts - 2,281 through 2,295 (of 7,504 total)