Viewing 15 posts - 76 through 90 (of 98 total)
This looks like the information I am trying to fully understand:
I am going to work through their scenarios!
Thanks for the help!
May 4, 2012 at 2:47 pm
This may be a ridiculous question, but would a full recovery database have more dependency on its log file? Making it more difficult to successfully restore the data files...
May 4, 2012 at 2:18 pm
Worked beautifully! Thanks! Now I need to test if that works if I pull the drive out, and don't properly detach it.
Thanks for the help!
Just noticed that it...
May 4, 2012 at 2:02 pm
I think the issue with my local computer's security. I was able to successfully test this with an XP machine, but not on my W7 machine. Don't want...
December 28, 2011 at 12:07 pm
Then use the import tool to import each file and then run the following update scripts.
For last name:
UPDATE A set lname = LN.lname FROM LastName LN WHERE LN.id = id
For...
December 27, 2011 at 8:03 pm
The best suggestion I would have for you would be to either start over using the import data tool available with Sql Management Studio, or you can create a temp...
December 27, 2011 at 7:46 pm
Can't really insert at this point, but you can run update statements on the existing rows.
You could literally do one at a time:
UPDATE A SET lname = 'lee' WHERE id...
December 27, 2011 at 7:28 pm
I have validated that the account has effective permissions of full control on the folder. If that is what you mean. To test this I have setup...
December 27, 2011 at 7:25 pm
Add the following to your e-mail script:
@body_format = 'HTML'
So it should look like this:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Admin',
...
December 27, 2011 at 10:53 am
I think I found my answer here:
http://www.simple-talk.com/sql/learn-sql-server/using-covering-indexes-to-improve-query-performance/
February 8, 2011 at 3:23 pm
The test does not duplicate the problem it only helps build context. Unfortunately I was not able to put a test together to duplicate the issue. I am...
February 7, 2011 at 11:58 am
I will have to study up on that. I should be more specific I suppose 🙂 I have maintained scripts that I have noticed that ROW_NUMBER was used...
January 13, 2011 at 3:38 pm
What is the script suppose to accomplish? From the way I read it you are trying to delete all rows that exists directly after (ID+1) a row that contains...
January 13, 2011 at 12:09 pm
I was trying to demonstrate the EXISTS syntax as a replacement for IN.
January 13, 2011 at 7:52 am
I don't know of a great way to do it, but I do know you could write a function that could loop through each row and reduce the content of...
January 12, 2011 at 9:46 pm
Viewing 15 posts - 76 through 90 (of 98 total)