Viewing 15 posts - 151 through 165 (of 476 total)
Kim Crosser (10/19/2015)
October 19, 2015 at 12:46 pm
If deleting, say, 90% of the table then worth considering "copying" the 10% to be retained into a new temporary table, and dropping old table / renaming temporary table. ...
October 18, 2015 at 1:33 am
IDENTITY_INSERT can only be ON for one table at a time. If it is ON for a different table, already / as part of a previous command that did not...
October 17, 2015 at 1:30 am
When we program a loop to bulk delete rows we adjust the Batch Size according to how long the iteration takes. We increase batch size by 20% if the...
October 17, 2015 at 1:08 am
We um-and-ah about having a subfolder for each database.
Whenever we need to port all the backups for all databases, and all log backups since the last FULL, to a different...
October 16, 2015 at 12:55 pm
fernando.arias (10/15/2015)
Msg 336, Level 15, State 1, Line 5
Incorrect syntax near 'Fernhl'. If this is intended to be a common table expression, you need...
October 15, 2015 at 4:54 am
peter-757102 (10/15/2015)
October 15, 2015 at 4:51 am
How does the APP write to a text file, for later bulk-import, in a multi-user friendly way? Isn't it going to have to open the file, lock it, read...
October 15, 2015 at 4:05 am
The error messages seem confusing to me (in light of your description). Wouldn't be the first time that a cascade of error messages has obscured the real issue ...,...
October 15, 2015 at 4:01 am
anthony.green (10/15/2015)
The default DB is master, the connection manager is then detailing which DB to point to.
I presumed that "DATABASE" in your message "Description: "Cannot open database "DATABASE" requested by...
October 15, 2015 at 3:49 am
I know nothing about this, just making some observations.
Elapsed time was 16.942 seconds - doesn't seem to tie with a Login Timeout of either 10 or 30 seconds?
"Cannot open database...
October 15, 2015 at 2:54 am
Our accounts department (all of two people, both part time ) uses an accounting package that requires the user to do backups / restores. Its definitely not using...
October 15, 2015 at 2:50 am
Might be worth adding your ID to make the Clustered Index unique (and then explicitly declaring the Clustered Index as UNIQUE) ... otherwise SQL will be adding a uniquifier value...
October 15, 2015 at 2:41 am
P.S. I presume the Clustered Index Key (i.e. on POLICY_TRANSACTION_BKEY) in your table [F_POLICY_TRANSACTION] is unique / PKey?
October 14, 2015 at 4:00 am
DamianC (10/14/2015)
Can anybody spot an error
Nope! :crying:
I'd suggest trying this to help with debugging:
SELECT TOP (0) IDENTITY(int,1 ,1) as ID, POLICY_TRANSACTION_BKEY
INTO #TEMP
FROM [F_POLICY_TRANSACTION]
-- Create a clustered index for efficiency
CREATE [highlight="#ffff11"]UNIQUE[/highlight]...
October 14, 2015 at 3:57 am
Viewing 15 posts - 151 through 165 (of 476 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy