Forum Replies Created

Viewing 15 posts - 8,341 through 8,355 (of 13,460 total)

  • RE: Turning off auto update of statistics

    I still disacgree with this, that's not what i got from TheSLGuru's comments:

    2. Turn auto update off on certain indexes with alter index.... set norecompute=on and update manually as needed

    As...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 2, 2010 at 6:28 am

    #1257828

  • RE: DROP Index problem

    it's the tablename: the table is not "testen.strasse", it is "testen" or "dbo.testen"

    the code is looking for a schema testen and a table strasse, which does not exist.

    ALTER INDEX strasse...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 2, 2010 at 5:36 am

    #1257803

  • RE: Results to merge customer names

    i think you'll have to have some ugly cleanups to try to find possible matches:

    SELECT * FROM

    (

    Select PK,

    REPLACE(

    REPLACE(

    REPLACE(

    REPLACE(

    REPLACE(

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 1, 2010 at 2:25 pm

    #1257624

  • RE: Copying Tables Between Databases

    ok, as Seth identified, there's plenty of ways to script tables...GUI, SMO, lots of script contributions.

    one of my articles out there is how to script a table via TSQL[/url]. by...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 1, 2010 at 10:44 am

    #1257500

  • RE: SELECT ...... WHERE .. NOT IN (SELECT...)

    the why is easy; NOT IN requires it a comparison to each value in the sub-select.

    really that is the same as saying :

    WHERE GR.NumDoc <> 1

    AND GR.NumDoc...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 1, 2010 at 5:38 am

    #1257262

  • RE: SELECT ...... WHERE .. NOT IN (SELECT...)

    when you use NOT IN, you have to prevent NULLs in your dataset:

    change query1 to this, and you'll get the expected resultsi think.

    select GR.NumDoc As Query1 from GR Where GR.NumDoc...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 1, 2010 at 5:32 am

    #1257257

  • RE: Searching Multiple Trace Files ?

    homebrew01 (11/30/2010)

    Lowell, I tweaked that a bit for my situation, and it worked quite nicely ... Thanks !

    sweet ! i was hoping to fiddle with that old thing after you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 6:10 pm

    #1257104

  • RE: Dev version

    she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?

    if the server was beefy enough to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 1:49 pm

    #1257023

  • RE: sick and itred of bcp

    ok so you are after more of a console application to run at the command line; still very doable in .net, but you need a lot of parameters, which can...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 1:42 pm

    #1257018

  • RE: sick and itred of bcp

    BLM I've got a .NET project that i built that, among other things, is my Developer Report Builder;

    I was re-inventing the wheel to improve my own skillset, and created...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 12:50 pm

    #1256985

  • RE: How to Reverse Engineer the Current Settings for sp_trace_create

    Mike Good (11/30/2010)

    Thanks, works great!

    thank you for the feedback! glad it helped you out!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 12:06 pm

    #1256949

  • RE: Searching Multiple Trace Files ?

    homebrew I've got an old script contribution out there that takes every trace file that happens to be in the same folder as the default trace, and imports it into...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 9:07 am

    #1256846

  • RE: Turning off auto update of statistics

    i worked in a shop where someone turned off auto update statistics, and with only 20 users hitting with an application, the database ground to a halt in less than...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 7:14 am

    #1256778

  • RE: Need to check who is connected:

    dsohal (11/30/2010)

    Hello,

    Thanks for your help, I guess it is going to help me, just couple of things, I am trying this in my development environment right now,

    1- How I can...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 6:22 am

    #1256735

  • RE: Automatic date command instead of manual change

    glad i could help! i had to do a search to find the reference you were talking about, where we participated in a different getdate() post a couple of months...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 30, 2010 at 6:07 am

    #1256729

Viewing 15 posts - 8,341 through 8,355 (of 13,460 total)