Viewing 15 posts - 1,756 through 1,770 (of 3,008 total)
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
Something like this is likely to work
use master
kill 75 -- the connection to the database in single user mode
use [MyDatabase]
alter database [MyDatabase] set multi_user with rollback immediate
If that doesn't work,...
June 23, 2009 at 10:23 pm
Page Life Expectancy is fairly low at 270 seconds, so you might consider adding more memory to reduce the IO. For example, up it to 64 GB.
The Average Page...
June 23, 2009 at 3:45 pm
jeffrey yao (6/22/2009)
I think "no primary keys, no constraints of any kind, no indexes, all columns were nullable, and dates were stored in varchar(8) instead of datetime." really has little...
June 22, 2009 at 1:57 pm
Viewing 15 posts - 1,756 through 1,770 (of 3,008 total)