Viewing 15 posts - 39,871 through 39,885 (of 49,571 total)
mzak (4/9/2009)
Is there any reason I should use one join over another?
Use CROSS JOIN when you really do want a cartesian product. Use INNER JOIN when you want exact...
April 9, 2009 at 11:14 am
UB (4/9/2009)
But the problem is .... the record gets inserted into Patient table and z_audit_Patient table.
Yes, it will. As Gus said, it's due to ownership chaining.
If that's not the...
April 9, 2009 at 11:08 am
Please don't post in all caps. It's the online equivalent of shouting.
April 9, 2009 at 10:59 am
Kavin (4/9/2009)
Anybody can guide me to move further..like what type of administration concepts they will ask and what type of simulation question will be there.
Answering either of those questions will...
April 9, 2009 at 10:55 am
UB (4/9/2009)
April 9, 2009 at 10:51 am
koustav_1982 (4/9/2009)
hi can anyone please forward me the link for free download of these materials
This site does not condone piracy or copyright violation. If you want to get the books,...
April 9, 2009 at 10:48 am
If the column will be containing 15-30 character and leading 0's are important, then you should make it a varchar(30) column.
Varchar has a 2 byte overhead for the storage of...
April 9, 2009 at 10:42 am
jungnaja (4/7/2009)
April 9, 2009 at 2:05 am
geramkumar (4/9/2009)
* no need create index on tables having little records or columns having duplicates (like country, gender etc).
Not necessarily. If the columns are filtered on often it may...
April 9, 2009 at 1:58 am
suhasini.m (4/8/2009)
April 9, 2009 at 1:47 am
Ells (4/9/2009)
but got multiple rows for tables so changed it slightly:
SELECT table_name,table_rows FROM (
select so.name as table_name, si.rowcnt as table_rows,ROW_NUMBER() OVER (PARTITION BY SO.NAME ORDER BY si.rowcnt DESC) AS RC
from...
April 9, 2009 at 1:42 am
Where is that drive backed up to and how long are those backups kept for?
April 8, 2009 at 2:52 pm
rodney.williams (4/8/2009)
April 8, 2009 at 2:50 pm
Robert Frasca (4/8/2009)
The point I was trying to make is that the assumption that table variables are better than temp tables because they are stored in RAM is false.
I...
April 8, 2009 at 2:49 pm
rodney.williams (4/8/2009)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows...
April 8, 2009 at 1:48 pm
Viewing 15 posts - 39,871 through 39,885 (of 49,571 total)