Viewing 15 posts - 19,951 through 19,965 (of 26,490 total)
Paul White (7/6/2009)
GSquared (7/6/2009)
Isn't that supposed to be all one word? (Alloneword, even.)That looks vaguely like German :unsure:
(Flo: consider Donaudampfschiffahrtsgesellschaftskapitän)
edit: better still:
Donaudampfschiffahrtselektrizitätenhauptbetriebswerkbauunterbeamtengesellschaft
or
Rindfleischetikettierungsüberwachungsaufgabenübertragungsgesetz
(Ok so I googled)
Care to translate??
July 6, 2009 at 3:25 pm
Are you saying your trying to return 25+ million rows? Is there a sort on the query? How wide is each record? How fast is your network...
July 6, 2009 at 3:23 pm
Please show us all the code you use to run the backups back to back in SSMS.
July 6, 2009 at 3:20 pm
vblllove (7/6/2009)
July 6, 2009 at 3:19 pm
Are you sure the full backup completes okay? Is there anything else happening to the database between the full backup and differential backup? Just for s and g's...
July 6, 2009 at 3:14 pm
Can you run the differential backup manually from SSMS?
July 6, 2009 at 3:07 pm
I don't think any further responses are necessary here, but here is an "interesting" omg moment.
July 6, 2009 at 3:02 pm
You could look at using Partitioned Views. Basically, you create a table for each year then build a view over the tables. You will find more information regarding...
July 6, 2009 at 2:58 pm
Why do you want to do this?
July 6, 2009 at 2:50 pm
yesso (7/6/2009)
July 6, 2009 at 2:48 pm
A good reason for the OP to be a bit more professional and expalin what the problem is instead of ranting about how much the site s****.
July 6, 2009 at 1:01 pm
Not sure as I am not using SQL Server 2008 (yet) and we currently aren't using SQLCLR, but it is possible that some of the internal processes may be using...
July 6, 2009 at 12:43 pm
arthykannan (7/6/2009)
July 6, 2009 at 12:35 pm
SCHEMA_NAME was added in SQL Server 2005. I don't know off-hand what you would use as a replacement in SQL Server 2000.
July 6, 2009 at 12:14 pm
Edward (7/6/2009)
1 the cursor selects only distinct ID's
2 each steps it selects from a different table using...
July 6, 2009 at 10:01 am
Viewing 15 posts - 19,951 through 19,965 (of 26,490 total)