Viewing 15 posts - 28,366 through 28,380 (of 39,771 total)
You can't easily do this in the maintenance plan. There needs to be logic to find the latest file, or read the msdb tables, to do this. It's not trivial,...
June 2, 2008 at 10:39 am
Nope, you can perhaps implement some loops to do this. I've used bcp to do this before. Some scripts on this site to help.
Best bet is build the DTS package,...
June 2, 2008 at 10:38 am
This can be tricky, and I don't think MS has done a great job explaining.
I've tended to look at BOL here (http://msdn.microsoft.com/en-us/library/ms190673.aspx) for guidance.
My understanding was AWE wasn't needed...
June 2, 2008 at 10:35 am
Permission to syscomments somehow?
Honestly the way to handle this is ensure your code is in a version control system. Keeping it on the server isn't really VCS.
June 2, 2008 at 10:30 am
I believe if you query Access, it goes through the DSNs configured inside the Access db to get to the data.
For the SQL stuff, you can setup a DSN the...
June 2, 2008 at 10:29 am
why cluster on VendorServiceID? You can have a primary key that's non-clustered.
Use the clustered index for one of the dates since they're often queries in ranges.
I don't think that <...
June 2, 2008 at 10:26 am
Search for cross tab queries.
There isn't an easy way to do this. You can do with with self joins, i.e.
select a.colA + ',' + b.colA from tableA a inner join...
June 2, 2008 at 10:24 am
Why would you need to know how many records in every table have been changed? That seems strange. I could see a few of them, but wouldn't lots of tables...
June 2, 2008 at 10:22 am
Keep posting here, and we'll try to help.
Honestly, I'd recommend you beg for some $$ to pick up one SQL 2005 book, any of the admin books (check half.com) and...
June 2, 2008 at 10:19 am
Also, is the code always slow? If you run it 10 times in the db and in tempdb, is it always slower in tempdb?
June 2, 2008 at 10:18 am
If the code is the same, why not deploy it to each database and call the code directly without worrying about dynamic SQL?
Having 40 copies of stored procedures in 40...
June 2, 2008 at 10:17 am
Are you moving all data from this table? You could move the clustered index (rebuild on the new file) instead. Not sure if the image data moves, but I would...
June 2, 2008 at 10:14 am
that is strange. Does it compile without the db name reference? Shouldn't matter, but not sure why this is a problem.
June 2, 2008 at 10:12 am
Some good advice, and there are a few articles on this site (search naming conventions).
I try to get things to group, since that's how I use them. So everything with...
June 2, 2008 at 10:10 am
Viewing 15 posts - 28,366 through 28,380 (of 39,771 total)