Viewing 15 posts - 706 through 720 (of 7,429 total)
Look at LEFT JOIN and RIGHT JOIN syntax in BOL. If the key value for connecting the database is null in the joined table (not the primary table) then no...
April 19, 2007 at 7:31 am
April 19, 2007 at 7:28 am
1. When I make the filegroup and move the tables in the designated file; are new records going to be saved in the new file or the old file?
Should save...
April 18, 2007 at 1:01 pm
April 18, 2007 at 12:54 pm
JUst to throw this in, I have a 13 year old who can't stand me when it comes to doing his homework. I won't let him use a calculator and...
April 18, 2007 at 12:51 pm
Both ways have their merrits, it really depends on the aplication, the security needs, how much interaction must occurr between systems, where the interaction has to actualy take place (I...
April 18, 2007 at 12:32 pm
You can only move the non-clustered to another filegroup if yu don't want to move the table as well. Remember a clustered index is part of the base table definition...
April 18, 2007 at 12:15 pm
I agree you might want to do the index changes via QA instead of EM. However keep in mind, when the clustered index is altered all indexes are forced to...
April 18, 2007 at 12:09 pm
Look at ou job definition. In the past I made the mistake of having two databases (one for UAT and one for Prod) on the same server and ran into...
April 17, 2007 at 2:12 pm
Read "After the Gold Rush: Creating a True Profession of Software Engineering" by Steve McConnell.
I think it explains the shortfalls of a CS degree versus what is really needed.
April 17, 2007 at 11:37 am
Thanks, I spent several months playing with DBCC PAGE and a few other undocumented items which helped me to understand what was going on inside the system. Reading the columns...
April 17, 2007 at 11:03 am
A lot of time the biggest savings you can find is just by normalzing the tables.
EX
Facilitites
Facility_ID int,
...
Published_Phone numeric(9,0) nullable,
Backdoor_Phone numeric(9,0) nullable,
Fax_Phone numeric(9,0) nullable,
Other_Phone numeric(9,0) nullable,
...
Was changed like so
Facilitites
Facility_ID tinyint,
...
Phone_Types
Phone_Type_ID int...
April 17, 2007 at 10:32 am
Right the server can be in standby, what I am concerned with is the actual DB was marked as read-only. Sp_Attach_DB cannot change that when loading and will error as...
April 17, 2007 at 8:32 am
OK I will take it a bit further and suggest they are wrong and you are right but you might want to carry a bit further.
But the reason I say...
April 17, 2007 at 8:24 am
No the trigger will cause a roll back and has no setting to change this fact. The reason is the system expects to complete all request items within the batch...
April 17, 2007 at 8:01 am
Viewing 15 posts - 706 through 720 (of 7,429 total)