Viewing 15 posts - 316 through 330 (of 1,033 total)
Koen Verbeeck (5/25/2012)
Went with my gut feeling on this and got it right.Great way to close the week.
Same here... 🙂 it makes sense... a database cannot serve two masters...
May 25, 2012 at 7:25 am
Toreador (5/24/2012)
I can't believe that 21% have currently got it completely wrong, thinking that OR has precedence over AND! Hopefully they're just all misunderstanding what 'precedence' means 😉
I think that's...
May 24, 2012 at 7:02 am
Well... you could always right click on the cluster and destroy it and then start over.
I don't have a lab cluster to play with, so I'm just exploring our production...
May 24, 2012 at 6:55 am
Which version of Windows?
If you setup a clustered file server, does it show back up?
May 23, 2012 at 8:01 am
Hugo Kornelis (5/23/2012)
mtassin (5/23/2012)
May 23, 2012 at 7:55 am
Hugo Kornelis (5/23/2012)
mtassin (5/23/2012)
BEGIN try
begin TRANSACTION
INSERT qotd2(col1,col2,col3) VALUES (1,'x','some')
INSERT qotd2(col1,col2,col3) VALUES (1,'Y','thing')
INSERT qotd2(col1,col2,col3) VALUES (2,'Z','or other')
COMMIT
END TRY
BEGIN CATCH
ROLLBACK
END catch
SELECT *...
May 23, 2012 at 7:34 am
Neil Thomas (5/23/2012)
So that means that when xact_abort is set to off thenBEGIN TRANSACTION
...
COMMIT TRANSACTION
does not do as expected.
What's the default setting on a fresh install of SQL?
But this...
May 23, 2012 at 6:54 am
Divine Flame (5/23/2012)
David in .AU (5/22/2012)
Just wondering how this works if I need to join tables between different databases, or is that one of those cases where it is listed...
May 23, 2012 at 6:48 am
Mike,
The logins are technically within the database at this point. It makes the database portable from instance to instance without having to clone the users from the original database...
May 22, 2012 at 9:21 am
Jeff Moden (5/20/2012)
Sarsoura (5/20/2012)
I would like to add a column which is the total scores for each student
This is one of the many reasons why I prefer CROSS TABs to...
May 21, 2012 at 1:58 pm
I think you could have also used
@execute_query_database = Product_Database
instead. it would have caused the sp_send_dbmail to change the database before executing the query.
May 21, 2012 at 9:41 am
SQL Kiwi (5/20/2012)
Surprising answer. I had no clue so guessed (wrong).
Same here... ah well 🙂 I figured it was either no pre-requisites or CLR... I had to guess...
May 21, 2012 at 7:30 am
You say ETL... are you using SSIS for the ETL?
If so, you can sometimes outperform merge by using the constructs within SSIS to mimic a merge.
Using a lookup to see...
May 18, 2012 at 9:13 am
Can you give us the actual schema of the tables in question plus some sample data?
See the link in my signature for help.
May 18, 2012 at 8:54 am
Viewing 15 posts - 316 through 330 (of 1,033 total)