Viewing 15 posts - 5,761 through 5,775 (of 9,715 total)
Lowell (6/16/2011)
i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know...
June 16, 2011 at 7:19 am
princa (6/16/2011)
Lowell (6/16/2011)
i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i...
June 16, 2011 at 7:17 am
I wish I could tell you otherwise, but unless you've got some other availability set up (log shipping, Database Mirroring, etc.), you're stuck doing it the old fashioned way.
June 16, 2011 at 6:41 am
Has anyone actually written an SSC article on how to write up and submit PASS abstracts?
I know I'd be interested in seeing the process as my abstracts tend to suck....
June 16, 2011 at 6:39 am
I like using subqueries and an Identity column. If you don't have an Identity, add it to the table. Then join the table to a subquery searching for the MIN()...
June 16, 2011 at 6:01 am
"Error" is a generic term in the SQL Server logs. You need to look at the Severity in order to understand if you're reading a true error or an informational...
June 16, 2011 at 5:55 am
DUPLICATE POST! Please direct all responses here: http://www.sqlservercentral.com/Forums/Topic1126304-149-1.aspx
June 16, 2011 at 5:46 am
We definitely need more information. If that is all the information, though, then FYI: Pivot does not work if you don't have something to aggregate on.
You need to SUM()...
June 16, 2011 at 5:44 am
viduvs (6/16/2011)
This is some critical issue we are facing in our production environment.
We have a production instance which was installed on SAN-LUN.
Somehow that LUN got deleted, and now SQL...
June 16, 2011 at 5:39 am
Don't just check the application log. Check the system log. It is more likely to have relevant information.
Also, the security log might give you information on who or what was...
June 16, 2011 at 5:35 am
Look into BEGIN TRANSACTION and END TRANSACTION. You'll probably want to name it. Try using the "new" TRY - CATCH functionality for error trapping.
You can find information on both of...
June 16, 2011 at 5:32 am
Has the backup device been created?
People who use third party tools or the GUI tend to forget that the T-SQL backup commands need that extra step.
June 16, 2011 at 5:25 am
Ditto what Gail said.
However, a lot of people I know use staging tables that they create and drop at need in a user db. These are permanent tables, even...
June 16, 2011 at 5:24 am
What kind of log files? Can you post a sample name for the log file?
I take it that an application would have these files open, rather than a person? If...
June 16, 2011 at 5:23 am
I prefer running an Update via a stored procedure in the Execute SQL Task myself. Merge Join takes a lot of resources that I can better use in other areas...
June 16, 2011 at 5:21 am
Viewing 15 posts - 5,761 through 5,775 (of 9,715 total)