Viewing 15 posts - 26,866 through 26,880 (of 39,791 total)
Is there an error logging switch? Some loaders can throw the bad records elsewhere.
Otherwise you need to look at the error and then try to figure out which row(s) it...
September 28, 2008 at 7:39 am
Change the script, figure out which process is doing what you need and don't kill that one.
September 28, 2008 at 7:38 am
The bcp/truncate works well if you can. I typically delete large sets of data in batches, 10k rows or so at a time. Seems to work faster.
You always want free...
September 28, 2008 at 7:36 am
What is "gets done"? Do you mean updated?
This is what you want. We don't want to have to update all instances with patches. You apply the patch twice.
September 28, 2008 at 7:32 am
SQL Server doesn't automatically delete the files, someone had to move them or delete them. I'd investigate moves. Search for them on the drives, a shaky mouse hand could have...
September 28, 2008 at 7:31 am
The groups will cause the user to be validated against AD with the trusted connection. This is what you're after, though it might seem a bit funny. When the user...
September 28, 2008 at 7:29 am
The design is fine for storing the data, but having those LIKE queries will slow you down and guarantee that the server works hard on every query.
You want to query...
September 28, 2008 at 7:28 am
Perhaps a silly question, but have you rebooted? i've seen that clear up some bad query plans.
Do you have any reference execution plans to examine the slow queries and see...
September 28, 2008 at 7:21 am
We tried this at one point and almost no one commented. Once they hit another site, they tend to comment there.
I think comments are best left on that site, with...
September 26, 2008 at 7:58 pm
Good point, and it might be something we ask Instant Forums (the maker of the software) to include it. I can see value in the OP.
Popping a new window doesn't...
September 26, 2008 at 7:57 pm
The backup name shouldn't matter, it's the data in there. You need the logical names to "move" the files, but you should just restore this file as a database name...
September 26, 2008 at 2:55 pm
You've got incorrect pathing, and the error is you're creating a folder that exists. There isn't error checking here on this, as the maintenance plans are very basic.
You don't want...
September 26, 2008 at 2:50 pm
If you have the required horsepower, and I don't think it changed much for Express, I'd go with 2008. No reason to go with 2005, which will be out of...
September 26, 2008 at 11:29 am
I'd recommend Itziks' books. If they get too complicated, move to the next section, but he does a great job going over things.
September 26, 2008 at 11:28 am
I think source control is good, but if you have a lot of developers, it can be rather cumbercome and confusing. What I'd do is once they think they have...
September 26, 2008 at 11:27 am
Viewing 15 posts - 26,866 through 26,880 (of 39,791 total)