Forum Replies Created

Viewing 15 posts - 316 through 330 (of 444 total)

  • RE: 5 yrs SQL Server experience, looking for 25-30hrs/week work

    I wish you were in Islamabad, Pakistan... I would have definitely hired you...

    Good Luck...

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: Timeout Expire: coz of sp?

    re-check your indices, and try to break this into pieces. i.e. try to break the calls (4 to 5 calls.) Also, set the query timeout to 0 (if necessary).

    Atif...

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: VarChar(max)?!?

    Nice...

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: Uncommon Table Expressions

    Nice Article. I would definitely like to go with this technique as there are very limited scenarios where you need huge documents to get parsed character by character. I have...

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: T-SQL Haiku

    GOTO FETCH CURRENT BACKUP

    RESTORE ON DATABASE FOR DUMMY

    BREAK TRANSACTION ON DUMP PROCEDURE

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: T-SQL Haiku

    GET PRIMARY DEFAULT USER

    TRY TO BREAK CURRENT TRANSACTION

    ALTER AUTHORIZATION TO CREATE CURSOR

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: intersting sql puzzle

    Ok... here it is...

    DECLARE @SpName varchar(10)

    SET @SpName = 'Y'

    SELECT DISTINCT ANTI_MISSILE.antim_id,ANTI_MISSILE.anitm_name FROM DEFUSE_CAPABILITY

    INNER JOIN ANTI_MISSILE ON DEFUSE_CAPABILITY.antim_id = ANTI_MISSILE.antim_id

    WHERE DEFUSE_CAPABILITY.antim_id IN

    (

    SELECT antim_id FROM

    (

    SELECT Count(*) AS xcnt ,antim_id...

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: SQL Brain

    my idea is to create at table with AttributeCategories, Attributes, AttributeValues and AttributeForm.

    Attribute Category my have the information like 'Demographics', 'School Information', 'Contact Information', etc with its Own Unique...

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: wii fit

    can someone explain what is 'wii fit'...?

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: How to list all the ports being used?

    There are alot of Port Scanner softwares on the web with source code. PortScanner is one of them.

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: Any SQL gurus / n00bs that are closet musicians?

    Playing Piano is one of my hobbies. I usually play it when i am tensed...

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    I must say that it is very interesting and informative article. I use the strategy very frequently and have suggested many others to use this.

    Great Article...

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: Find distinct special characters in column

    You can find the special characters at the database end by using ASCI codes. this will require string parsing. can be done using tally tables or looping through each cahracter...

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: MySQL Primer for the SQL Sever DBA

    Nice article...

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • RE: Find distinct special characters in column

    Are you having problem in Insertion / updation or in querying the records...?

    I think inall cases, you should check the special characters (that can cause error in the query if...

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

Viewing 15 posts - 316 through 330 (of 444 total)