Viewing 15 posts - 1,786 through 1,800 (of 2,647 total)
This is what sample data should look like:
USE tempdb
CREATE TABLE TableA (textName CHAR(3))
INSERT INTO TableA
SELECT 'ABC'
UNION ALL
SELECT 'DEF'
UNION ALL
SELECT 'GHI'
CREATE TABLE TableB (Id int, ind int, textname char(3))
INSERT INTO TableB
SELECT...
February 2, 2012 at 12:57 pm
Evil Kraig F (2/1/2012)
SQLKnowItAll (2/1/2012)
February 1, 2012 at 2:37 pm
Just from looking at your errors and not knowing anything about TDP, I can only guess that something has changed ans is adding a timestamp to the database for which...
February 1, 2012 at 2:25 pm
Awesome... So for the test, it is what it is. In practice, as always, it depends 🙂 Can you give an example of a situation where you would...
February 1, 2012 at 1:53 pm
GilaMonster (2/1/2012)
SQLKnowItAll (2/1/2012)
What happens when you put your where conditions into your join?
If you're talking about the update, nothing will happen. It's an inner join, conditions in the where or...
February 1, 2012 at 12:11 pm
Perry Whittle (1/30/2012)
ananda.murugesan (1/27/2012)
Should I use in Single primary filegroup and create multiple files MDF for using application date, NDF for using index if created?thanks
ananda
Do you have a valid reason...
February 1, 2012 at 12:08 pm
What happens when you put your where conditions into your join?
February 1, 2012 at 11:58 am
If it is a lot of data and you do not want the overhead of deletes, I would insert the 10 rows you want to keep into a temp table,...
February 1, 2012 at 9:52 am
When you are creating the Data Source, are you selecting Create New SQL Server Database or are you selecting Add Connection? Tell me then which configurations you select.
February 1, 2012 at 9:37 am
To connect to a running server, you have to specify the proper connection properties. Can you attach a screen shot of your properties for the SQL Server Enterprise machine?
February 1, 2012 at 9:33 am
So let me try to make this clear to you if I can:
A server side trace means that the trace is running on the server. It is still using...
February 1, 2012 at 9:00 am
You did all the work there yourself, we (mostly Koen) just pointed you in the right direction. Great job!
January 31, 2012 at 6:05 pm
I believe this is because the drive was mapped to your user which is not seen by the SQL Server Agent. Good catch though!
January 31, 2012 at 3:27 pm
sam_rao_sam (1/31/2012)
January 31, 2012 at 2:35 pm
Viewing 15 posts - 1,786 through 1,800 (of 2,647 total)