Viewing 15 posts - 15,931 through 15,945 (of 39,921 total)
I'm not clear what you mean. Are you looking to read the names of all the files and store them in a table or something more?
Does this help? http://www.sqlservercentral.com/blogs/stratesql/archive/2011/1/31/31-days-of-ssis-_1320_-importing-execution-plans-_2800_30_2F00_31_2900_.aspx
June 12, 2011 at 9:45 am
To add to Grant, when you restore a database, or a log, the engine does redo/undo, which is essentially rolling forward and rolling back. Items in the log that were...
June 12, 2011 at 9:43 am
If you are trying to log all data changes from any column in any table, you are going to make coding this very complicated.
You'd be better off building a template...
June 12, 2011 at 9:39 am
How about Most Valuable Lurker, Bob? We could quiz you in Dec on the contents of The Thread
June 12, 2011 at 9:36 am
No need to apologize, and we want you to ask questions, but really more pointed questions. The suggestion to Google is for you to try to learn something about it...
June 12, 2011 at 9:33 am
You can index some native type documents, like Word as well. I would assume PDFs would count, but you'd have to experiment
http://www.codeproject.com/KB/architecture/sqlfulltextindexing.aspx
June 12, 2011 at 9:31 am
But you know what the new data is, so why can't you send in the audit first? Or select the OLD data and store it before the update?
If it doesn't...
June 11, 2011 at 4:31 pm
I'm not sure The Thread counts for MVP status, but you never know. Some people certainly have made quite a contribution here 🙂
June 11, 2011 at 4:30 pm
George, George, George, George
(just in case once wasn't enough)
June 11, 2011 at 1:00 pm
If it's the same connection, why do you have to do the update first?
June 11, 2011 at 9:54 am
If it's last workday and holidays come into play, then you need scripting. There are a few good calendar table articles here. I'd build one and then use a short...
June 11, 2011 at 9:53 am
Craig has some good questions. Performance monitor has some counters, but depending on how you answer Craig's questions, they may or may not work
June 10, 2011 at 6:25 pm
L2 cache is built into the chip. You cannot set it. When you buy hardware, you pick a CPU with at least 2MB of L2 cache.
June 10, 2011 at 6:23 pm
You definitely need logins and users early, perhaps roles as well. I think you have a good list there.
Here are some things I learned awhile back. I didn't have users...
June 10, 2011 at 6:22 pm
Whatever code page you used for posting has mangled this so that it's a little hard to read.
Also, no error message is shown
June 10, 2011 at 6:11 pm
Viewing 15 posts - 15,931 through 15,945 (of 39,921 total)