Viewing 15 posts - 1,756 through 1,770 (of 3,011 total)
How often are you running transaction log backups?
Running them more often prevents the transaction log file from growing so large. I usually setup transaction log backups to run every...
June 30, 2009 at 3:25 pm
Paul White (6/30/2009)
...
That trick with the CASE is clever. I guess my only small concern would be that it depends on SQL Server not evaluating the ELSE when a...
June 30, 2009 at 12:08 pm
The batch requests per second seems a bit high, but without know more about the application, it's hard to say.
A batch request rate that high might be an indication that...
June 30, 2009 at 9:47 am
ta.bu.shi.da.yu (6/26/2009)
...
I've never tried adding a FK that referenced a non-PK column. Is that even possible?
You can add a FK as long as the columns that you reference have a...
June 30, 2009 at 9:18 am
Paul White (6/29/2009)
Michael Valentine Jones (6/29/2009)
June 30, 2009 at 9:05 am
Queries for a date range should normally be in this form:
where MyDatetimeColumn >= @StartDatetime and MyDatetimeColumn < @EndDatetime
In other words greater than or equal to the first point in...
June 29, 2009 at 9:23 pm
The wish list is nice, but in the end is probably unrealistic. The basis of a job is to get you to do something that you wouldn't do if...
June 29, 2009 at 9:07 pm
Paul White (6/29/2009)
...
More 'fun':
SELECTTOP (100)
ROW_NUMBER() OVER (ORDER BY C1.[object_id]) AS N,
FROMmaster.sys.columns C1
ORDERBY A, (1 / CASE WHEN COUNT(*) OVER () = 100 THEN 1 ELSE 0 END);
I'm not sure what...
June 29, 2009 at 8:43 pm
Paul White (6/29/2009)
Michael Jones
June 29, 2009 at 4:03 pm
Whatever the reason that Peter has for the stripped down master database, his point is valid about making sure that the system table you use has enough rows.
Personally, I avoid...
June 29, 2009 at 10:17 am
I have a hard time understanding how agile development would work within the biggest trend in software development, outsourcing development to offshore teams that have little direct involvement with the...
June 28, 2009 at 7:36 pm
select
*
from
MyTable
where
-- Greater than or equal to...
June 27, 2009 at 10:53 pm
Apollo74x (6/24/2009)
Michael Valentine Jones (6/23/2009)
The Average Page Lookups/sec and the Page Reads/sec 677 seem low considering the low Page Life Expectancy. What does the CPU usage % look like?
The...
June 24, 2009 at 5:55 pm
bryan van ritter (6/24/2009)
June 24, 2009 at 1:47 pm
bryan van ritter (6/24/2009)
June 24, 2009 at 9:04 am
Viewing 15 posts - 1,756 through 1,770 (of 3,011 total)