Forum Replies Created

Viewing 15 posts - 15,901 through 15,915 (of 19,564 total)

  • RE: Creating Indices on Temp Tables from Stored Procedures

    TheSQLGuru (3/26/2010)

    ...

    Do a proper indexing strategy analysis on this table and a) get rid of indexes that shouldn't be there and b) create ones that should. Any other action...

    March 26, 2010 at 8:16 am

    #1140376

  • RE: SQL Server 2008 T-SQL Enhancements Part - IV

    Thanks for another article in this series.

    March 26, 2010 at 8:11 am

    #1140370

  • RE: migratation from sql server 2000 to sql server 2005

    arr.nagaraj (3/26/2010)

    Oopsie..I didnt read the question correctly. Just saw OP's 'what abt jobs' and replied.

    Apologies shinobigoh and Jason for my dumb response.

    I would disagree that it was a dumb response....

    March 26, 2010 at 8:04 am

    #1140359

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/26/2010)

    Alvin Ramard (3/26/2010)

    Nice map site.

    Oh I get it now! Sorry Gianluca.

    My antipodal point turns out to be halfway between Madrid and Salmanca, in Spain. Interesting!

    My...

    March 26, 2010 at 8:02 am

    #1140356

  • RE: migratation from sql server 2000 to sql server 2005

    arr.nagaraj (3/26/2010)

    Jason:

    This is about the cheapest method.

    Recession has taught us that we need to resort to the cheapest option where ever possible 😀

    It's also probably the easiest. But...

    March 26, 2010 at 7:52 am

    #1140348

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (3/26/2010)

    Dixie, you collect on that one and I will be proud to tell folks that I am your evil twin!

    Hey, I've got a couple free hours a...

    March 26, 2010 at 7:32 am

    #1140327

  • RE: T-SQL Oddities

    John McC (3/26/2010)

    Ah.

    That would explain why I couldn't find the b@##y st??%d table

    I think so.

    Another reason could be that the table changes names daily. Guess what it is...

    March 26, 2010 at 7:10 am

    #1140309

  • RE: migratation from sql server 2000 to sql server 2005

    arr.nagaraj (3/26/2010)

    You can always script all the jobs from Enterprise manager from

    Management->SQL server agent->All tasks->Generate SQL scripts

    generates the script for all the jobs on the server

    This is about the...

    March 26, 2010 at 7:09 am

    #1140305

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/26/2010)

    That missing cert thread went crazy. I saw the notifications yesterday, but couldn't respond in meetings. There's no winning it, especially when there is someone that...

    March 26, 2010 at 6:59 am

    #1140295

  • RE: The Missing Certification

    Steve Jones - Editor (3/26/2010)

    I've heard, not sure if it's true, that the MS exams typically are around 200 questions, which is a low pool.

    I've heard the same.

    March 26, 2010 at 6:58 am

    #1140292

  • RE: Policy-Based Management

    Thanks. This was still fresh in memory from the last question you posted. I had to do a lot more research that time.

    Good question.

    March 25, 2010 at 10:57 pm

    #1140129

  • RE: The Missing Certification

    Gift Peddie (3/25/2010)

    This is true with most standardized exams from LSAT, GMAT and GRE exams add in the colleges that professors leave past tests at the school library. The software...

    March 25, 2010 at 6:33 pm

    #1140093

  • RE: Object comparison between servers

    Despite that kind of restriction, you could still use the redgate tools to perform the comparison. Redgate allows you to compare files for differences. Thus you would only...

    March 25, 2010 at 6:27 pm

    #1140091

  • RE: Are the posted questions getting worse?

    RBarryYoung (3/25/2010)

    CirquedeSQLeil (3/25/2010)

    RBarryYoung (3/25/2010)

    No, that's not quite how I would put it. I would say however, that there are some people who clearly create the vast majority of their...

    March 25, 2010 at 6:07 pm

    #1140088

  • RE: Object comparison between servers

    Angelindiego (3/25/2010)

    sorry all....I wasn't thinking earlier...the reason it has to be done by script and automated thru a job is that the servers being queried are in a place where...

    March 25, 2010 at 6:04 pm

    #1140087

Viewing 15 posts - 15,901 through 15,915 (of 19,564 total)