Viewing 15 posts - 1,096 through 1,110 (of 1,291 total)
Alright, I started to reply to this post before Steve's reply and have to edit much of the content since it would be repetitive.
As already mentioned by Steve, this is...
November 12, 2009 at 8:40 am
Your concern is can be understandable, but if it is a table of Quarter of a million records it should be ok to run on top of it rightaway, when...
November 12, 2009 at 8:27 am
From my understanding, you are planning to move the distinct from this table to a new table (Step1) and then apply 15 different Summations / Aggregation on top of that...
November 12, 2009 at 8:15 am
Hi, I got your requirement.
I am not sure 100% about the suggestion I am about to give, since I have not done this anytime.
You can have the Same Host Name...
November 12, 2009 at 5:56 am
What does the Error Log Files show? Any information in them?
Do you see any peculiar activity that caused this. Since when did this restarting issue begin, did you change...
November 11, 2009 at 10:23 pm
There is nothing as such T-SQL Certification, you have it as Database Developer.
70-431 is for MCTS (it is common for either Database Admin or Database Developer) and it is a...
November 11, 2009 at 10:09 pm
There is nothing as such T-SQL Certification, you have it as Database Developer.
70-431 is for MCTS (it is common for either Database Admin or Database Developer) and it is a...
November 11, 2009 at 10:08 pm
Agreed, the script works fine and good work for making it to here.
I ran the script, and got 22 Records. That's all I have as as of now.....
regarding your post...
November 11, 2009 at 9:12 pm
chinn (11/11/2009)
we added indexes that did it..It was done in 5 mins.
Thanks,
That's a good News !
November 11, 2009 at 3:15 pm
Some other features which are not mentioned, such as Resource Governor, Policy Based Management, Change Data Capture, Transparent Data Encryption, Database Partitioning, HA feature DB Mirroring and Peer-to-Peer Replication and...
November 11, 2009 at 3:14 pm
The Basic things that you would like to install would also depends on what your server needs to to be installed.
You have a choice to install one or more of...
November 11, 2009 at 3:07 pm
UPDATE tbl1
SET tbl1.col1 = db2.dbo.tbl2.col1 ,
[tbl1].[col2] = db2.dbo.tbl2.col2
FROM tbl1, tbl2
where tbl1.col3 =db2.dbo.tbl2.col3
and tbl1.col4 = db2.dbo.tbl2.col4
To start with, why Not rewrite the script like this
UPDATE...
November 11, 2009 at 1:29 pm
select 6035IN,101244488,13,6/9/2009,711,0,,,0,0,DUP,6/12/2009,711,0,5/26/2008,9999,,UNION ALL
Select 6035BD,101244488,,10/24/2008,711,0,,,0,0,HRT,3/2/2009,711,0,5/26/2008,9999,,UNION ALL
I think the string and Date values need a ' ' ...:-)
November 11, 2009 at 12:33 pm
To clear the confusion, can you come up with the correct create table script and also few Insert Stmts (may be 5) to display what it is and what you...
November 11, 2009 at 12:05 pm
Viewing 15 posts - 1,096 through 1,110 (of 1,291 total)