Viewing 15 posts - 556 through 570 (of 961 total)
From what you have posted it seems pretty obvious that your missing an index in stg so the query takes longer. It would be helpful if you include the actual...
August 16, 2011 at 12:11 pm
Ideally the primary key should consist of column that have actual data rather than system generated values.
for example for a table like customer , the emailid would be a good...
August 16, 2011 at 4:09 am
Is there cross domain authentication possible between A and B ie do they trust each other ?
Replication with a UI front seems to be good fit for what your trying...
August 16, 2011 at 2:18 am
Try downloading and installing the file once more.
http://www.microsoft.com/download/en/details.aspx?id=7593
You can check you event viewer to see if there were any errors raised during the installation.
SSMS is available only ofr x86 and...
August 16, 2011 at 2:08 am
jsmithadd (8/16/2011)
could you please clarify the below questions.
What if during a Log Shipping Process correct log is not transferred.?
Log shipping fails until you restore the correct log file
How do we...
August 16, 2011 at 1:43 am
There isn't a perfect fit for the lead and lag in oracle but you can use the OVER clause to create a window function.
August 16, 2011 at 1:36 am
I don't think this sp is available in sql 2000 . I think the better option is to write a batch file to perform the delete.
You could also...
August 16, 2011 at 1:32 am
The database backup is a copy of the database as is . The statistics will not under go any change from that of the original database from which the...
August 16, 2011 at 1:27 am
Have you tried start>run>ssms.exe
August 16, 2011 at 1:22 am
Understanding normalization is a good start.
Followed by examples such as those in Adventure works.
BOL is a good source too.
Mostly Good Db design comes with practice. So that's they way to...
August 11, 2011 at 5:52 am
Erwin and ERStudio are the favorites , Ive seen them in almost every company I worked for. Visio is good but the newer version will not create a database from...
August 11, 2011 at 5:26 am
At one point I used to travel 2 hours to work and 2 hours back. Since then I have relocated closer to work and haven't had to travel more than...
August 11, 2011 at 5:24 am
heres what wiki has to say about this
Windows Internal Database (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a variant of SQL Server Express 2005 that...
August 11, 2011 at 5:16 am
I didn't do 70-433 but the study plan is usually the same for most exams. The key here is to find what works for you.
After many years experience may be...
August 11, 2011 at 5:08 am
what data type are you using , if your using int change it to decimal (5,2)
August 11, 2011 at 4:25 am
Viewing 15 posts - 556 through 570 (of 961 total)