Forum Replies Created

Viewing 15 posts - 5,641 through 5,655 (of 6,025 total)

  • RE: NEW SEQUENCE NUMBER DAILY?

    Brandie Tarvin (4/6/2011)

    Now that's a clever solution. I like the use of Rank, Partition, and Right there.

    One caveat to using the ranking method is that each row is ranked dynamically...

    April 6, 2011 at 7:50 am

    #1308022

  • RE: NEW SEQUENCE NUMBER DAILY?

    DMS11X (4/4/2011)

    Can someone mark this thread as solved? So if anyone else needs help...

    Looking at your sample resultset above, it seems to me that the column SequenceNumber is derived...

    April 5, 2011 at 4:30 pm

    #1307758

  • RE: Analyzing an Unfamiliar and Undocumented System

    Well, the good news is that you've got your work cut out for you and don't need to worry about getting laid off anytime soon.

    In most large proprietary databases...

    April 5, 2011 at 2:24 pm

    #1307702

  • RE: Execution Plan for Newbies

    If you're not sure what to look for, then consider using the DTA (Database Engine Tuning Advisor) tool to analyze your query.

    April 4, 2011 at 12:14 pm

    #1307108

  • RE: 'T-SQL' Connect Remote SQL Server !

    asterman_3 (4/4/2011)

    Actually, I want to know whether it is possible to create a procedure from T-SQL on remote server, and than execute. Or, to create a SQL Job remotely (on...

    April 4, 2011 at 9:38 am

    #1307055

  • RE: 'T-SQL' Connect Remote SQL Server !

    asterman_3 (4/4/2011)

    Thank you for the detailed explanation. It works!

    I have another question.

    How can I CREATE a PROCEDURE on the remote sql server?

    You should create a procedure on the remote database...

    April 4, 2011 at 9:15 am

    #1307038

  • RE: 'T-SQL' Connect Remote SQL Server !

    asterman_3 (4/4/2011)

    Hi,

    I need help. I want to connect to a remote SQL Server. So, can someone exactly describe the T-SQL scripts needed for this?

    Thank you!

    One method is to create...

    April 4, 2011 at 9:08 am

    #1307033

  • RE: The Chance of Failure

    Steve Jones - SSC Editor (4/1/2011)

    H-122523 (4/1/2011)

    Hi Steve,

    Interesting editorial, this, as it connects failure to probability.

    In the end, we all make up the statistics; I just finished 'The Black...

    April 1, 2011 at 1:44 pm

    #1306674

  • RE: The Chance of Failure

    If Joe's Bike Shop looses all their data without a backup, then that's a personal tragedy for their business, but it's not really a community or regional wide disaster. The...

    March 31, 2011 at 10:09 am

    #1306082

  • RE: The Chance of Failure

    Disaster recovery is actually easier in the modern IT world than it was in times past. One hundred years ago, if the county courthouse burnt to the ground, much of...

    March 31, 2011 at 8:08 am

    #1305989

  • RE: Hacking Data

    CirquedeSQLeil (3/24/2011)

    I find this editorial interesting in that I had a recent discussion concerning new car models that have wifi enabled in the car. The wifi in these cars...

    March 24, 2011 at 11:19 am

    #1303118

  • RE: Do You Need A Safe Word?

    In most large corporations, everyone has an employee number which they know from memory becuase it's on their payroll stub or they enter it when dialing into a tele-conference call....

    March 24, 2011 at 10:48 am

    #1303104

  • RE: Hacking Data

    GSquared (3/24/2011)

    Eric M Russell (3/23/2011)

    An MP3 player and an automobile engine are two unrelated systems that should not be tightly coupled.

    Does the MP3 player double as a control for your...

    March 24, 2011 at 7:58 am

    #1302981

  • RE: Hacking Data

    hnhaney2 (3/24/2011)

    Once you understand that the car run a CAN network system between all major system, it's no different than network hack in the internet, Other than it CAN network,...

    March 24, 2011 at 7:37 am

    #1302964

  • RE: Hacking Data

    An MP3 player and an automobile engine are two unrelated systems that should not be tightly coupled.

    March 23, 2011 at 5:14 pm

    #1302761

Viewing 15 posts - 5,641 through 5,655 (of 6,025 total)