Forum Replies Created

Viewing 15 posts - 1 through 15 (of 334 total)

  • Reply To: Create temp table in Openquery?

    Openquery runs on the remote server and returns the result set.  4 part names runs local and has to suck the data across the network needed for the query.  There...

  • Reply To: substring + chrindex

    You could try something like this to make it work.

    CREATE TABLE #DATACONTENT(line VARCHAR(MAX))
    INSERT INTO #DATACONTENT VALUES ('\\A1-SRV-05\REPRISE-sollyaza\Allian_ged\NOVAXEL\ALLIAN_1\C842183\CARREFOUR SANTE REPRISE\160010210006\documents entrants\Courriers divers_12470290.pdf')
    INSERT INTO #DATACONTENT VALUES ('\\A1-SRV-05\REPRISE-sollyaza\Allian_ged\NOVAXEL\ALLIANZ_1\CAL000010\Volvo Allianz\VAZP100027\documents entrants\001-Doc...
  • RE: Whats wrong in this query

    Try to add a query hint to eliminate the loop join and turn it into a hash or merge. Are statistics current on the tables.

    Tom

  • RE: Database in use

    I will usually connect to master, kill all connections to the database in step 1 and then start my restore in step 2.

    I've never been blocked when I've...

  • RE: rebuild index worsens query performance

    It looked like your plan timed out on generation. So it's just choosing whatever its on and running it. This is probably happening everytime the query is running and...

  • RE: Indexes evaluation

    It looks like it's using the clustered index almost exclusively for all data access. I don't know if that's by design or if you thought it would use the...

  • RE: Help diagnosing performance issue

    You can try looking at the query plan to see if it doing tablescans during the procedure, and index appropriately. I would definitely read the link about parameter sniffing....

  • RE: Space Problems

    I'm wondering if someone didn't corrupt the file(xls) and change the column types. Have you tried creating a new xls template for importing. Is everyone having problems with...

  • RE: Space Problems

    I forgot to ask, what datatypes are in the table being inserted into.

    Tom

  • RE: Space Problems

    How many indexes are on the file. I would try dropping the indexes from the file and retry. Is this a new process? I would also, if...

  • RE: Shrink the log file size

    The first thing you need to do is to truncate the t-log. backup log <db> with truncate_only.

    Then issue the dbcc shrinkfile (filename,size)

    If your going to keep this in simple...

  • RE: Table - UnusedSize

    Is there a clustered key on this table. If there is then the dbcc dbreindex will free the space. If not, than nothing you do will re-org this...

  • RE: Is there any way - Using Like Operator - throws Index Scan - change to Index Seek

    You could try to create another column that reverses the phone number, index that and then reverse the input of the search and search based on the new column in...

  • RE: How to keeps log of StoredProc executions

    If you run this as a scheduled job, you should be able to use a job log and the print statements should write out to that. It is on...

  • RE: Poor query performance post SQL 2008 upgrade

    Can you try setting the compatibility flag back to 8.0 and see if the queries performance increase while you research the problem. I have read that instead of a...

Viewing 15 posts - 1 through 15 (of 334 total)