Forum Replies Created
Viewing 15 posts - 36,016 through 36,030 (of 39,771 total)
-
RE: Quiet here
Interesting idea. I'll ask Brian about this.
Steve Jones
-
RE: SQL Server Mag User Study
Hey, I didn't get a link!!!!!
Actually I don't think they like us very much.
A couple years ago, before we were competitiors, I did the survey and...
-
RE: >100,000 Members ? HippHippHurray !!!
Thanks for the note Frank and I know your posts are very valuable on average.
Steve Jones
-
RE: Where Do I Want To Go Today? - From the Field
I like changing the concatenation operator. Never liked plus being the same as "and this".
Steve Jones
-
RE: Backup MS SQL server
Sorry, haven't used that version.
BTW, I think you'll find the consensus on this site from most experienced DBAs is not to use an agent.
Steve Jones
-
RE: can this script be made quicker/easier
Not sure if it can because the xp_cmdshell doesn't take a set as an argument.
Steve Jones
-
RE: Missing xp_sendmail
They should be there. I'd install another instance and just copy them over.
Steve Jones
-
RE: Sql Srv 2000 Enterprise Mgr Backups
We use TSM and the unique filenames are a blessing as we may need to go back to a particular day. You can setup a special retention polocy (which is...
-
RE: Database Performance
Tough one without more information. Indexing differently, reducing the set sizes byu perhaps moving data from tables might help. Indexed views might work depending on the update levels.
Of course many...
-
RE: SQL Server Security: Pros and Cons of Application Roles
Nicely written Brian and shares many of my same views. I've tended to handle inappropriate access (like not using the applicaiton) administratively. A chewing out, a writeup, or a termination...
-
RE: Maintenance Plans
Was this an old name? I htink this is probably left over from an old maintenance plan. If under the Maintenance Plans folder (under Mangaement), there is not a maintenance...
-
RE: Newbie: continuing backup failures
Also check the maint plan logs. Look at the properties for the maintenance plan to see where the job is being logged and check out the log files for an...
-
RE: Comparing two tables
No, you'd need to compare each column. Comparing PKs is easy, but that won't tell you if all data is the same.
Steve Jones
Viewing 15 posts - 36,016 through 36,030 (of 39,771 total)