Viewing 15 posts - 10,516 through 10,530 (of 39,768 total)
s.bradbury (9/26/2014)
September 26, 2014 at 7:46 am
no simple way.
If you have modified dates in your tables, check those.
If you track insert dates, look there.
Check on sizes of log backups. Larger ones may help you determine times...
September 25, 2014 at 3:53 pm
The log fills with transaction activity. Something created lots of log records, so you'd have to find a lot of data changes or inserts. (or maintenance).
The log clears with log...
September 25, 2014 at 2:46 pm
Thanks, but this is falling on dead ears.
We are working to implement some SPAM prevention measures and change some code. Hard to get this to be a priority, though.
September 25, 2014 at 2:40 pm
I couldn't imagine how this would be a problem, but there must be some counting.
I've struggled with developers to fix it, which seems odd to me since it must...
September 25, 2014 at 12:38 pm
Many people think of this as random. I was trying to point out that there can be issues. I wasn't trying to point out all issues, though I'll change the...
September 25, 2014 at 11:09 am
I think you're both napping, Ray.
I was working with the laptop on my legs and the kitty kept attacking my typing fingers. This was about 15 minutes later, she called...
September 25, 2014 at 10:21 am
lshanahan (9/25/2014)
How data is collected is just as important as quantity if not moreso, as...
September 25, 2014 at 10:06 am
There's nothing right or wrong about aliasing. It's preference.
I try to use them often, because I find many queries quickly get complex and it's much harder for me to read:
select...
September 25, 2014 at 9:48 am
edwardwill (9/25/2014)
Can you explain why you aliased the sys.syscolumns table?
SELECT TOP 10RAND( ROW_NUMBER() OVER (ORDER BY id))
FROM sys.syscolumns
is functionally identical, as far as I am aware.
habit
September 25, 2014 at 8:45 am
Andrew G (9/24/2014)
SQL 2000: Error 'Row_Number' is not a recognized function name.SQL 2005 to 2012: 10 distinct rows returned, answer should be C.
you should never expect any of our questions...
September 24, 2014 at 10:23 pm
Arrggg, wrong box checked.
10 is correct. I'll award back points tomorrow.
September 24, 2014 at 10:23 pm
Viewing 15 posts - 10,516 through 10,530 (of 39,768 total)