Forum Replies Created

Viewing 15 posts - 11,041 through 11,055 (of 13,460 total)

  • RE: Restrict recource usage on query?

    ok here's a best guess;

    the execution plan has a portion of the query in it..something like the first 4200 characters or so, so i didn't have all the joins...i inveted...

    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!

    June 1, 2009 at 8:54 am

    #1002808

  • RE: Invalid column name help

    ##Errors is a global temp table...the two pound signs make that global instead of just for your proc.

    a global temp table is visible to all other processes that might need...

    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!

    June 1, 2009 at 6:38 am

    #1002705

  • RE: Create table

    Scott Coleman (6/1/2009)

    We now now a unique constraint won't work for the Customer table - they're all named John. :w00t:

    lol:

    (IS for brothel)

    i saw that too, and was wondering...

    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!

    June 1, 2009 at 6:25 am

    #1002693

  • RE: Restrict recource usage on query?

    save it as a SQLplan...that's just xml. you can throw it in a zip file , and then attach it here to a followup post.

    when we open it in SSMS,...

    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!

    June 1, 2009 at 6:22 am

    #1002689

  • RE: Restrict recource usage on query?

    Rob SQL2008 has an actual CPU governor for that situation...preventing any one query frome ating all resources...it's not in 2005.

    a 20 minute query is unusual, unless you are threshing thru...

    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!

    June 1, 2009 at 6:17 am

    #1002684

  • RE: Query to get the minimum id

    ahh you changed it on me since i posted....

    i would switch tou using the row number function then...see how this works for you.

    run the inner query so you can see...

    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!

    June 1, 2009 at 6:08 am

    #1002673

  • RE: Query to get the minimum id

    way to go on posting the table and data! it made it really easy to try and help!

    here's two examples; in one i figured you jsut wanted the ID, and...

    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!

    June 1, 2009 at 5:57 am

    #1002669

  • RE: Should blobs be stored in a separate table?

    the typical "it depends";

    I'd take into consideration whether there is a possibility that the blobs would be one-to-many for the main record. even if "today", you are only capturing...

    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!

    June 1, 2009 at 5:48 am

    #1002662

  • RE: Encrypt Char Column

    you'll need to change your encrypted column to a varbinary. I believe the rule is if you are doing a 19 char field, the size for the varbinary is twice...

    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!

    May 31, 2009 at 8:33 pm

    #1002537

  • RE: Script all indexes as CREATE INDEX statements

    i contributed that script a while ago, and clearly it's only for SQL 2000;

    here's someone elses script that I saved in my snippets that does INCLUDE columns;it does PRINT statements...

    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!

    May 31, 2009 at 7:57 pm

    #1002535

  • RE: Link Access tables to SQL server

    if they are doing the setup, figure out which tables you will be using, and get them to add synonyms for those tables as well...it really makes your sqls cleaner:

    IF...

    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!

    May 29, 2009 at 10:07 am

    #1002155

  • RE: XML Code Tags

    there's a thread on the new updated codeing somewhere, but i happened to keep the list handy in my snippets:

    note that there's a space between the bracket and "code" so...

    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!

    May 29, 2009 at 9:58 am

    #1002153

  • RE: Link Access tables to SQL server

    here's the syntax and example of adding a linked server for an access database, the login for it, viewing the list of tables, selecting from one, and finally updating one...

    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!

    May 28, 2009 at 4:41 pm

    #1001836

  • RE: sp_AddLinkedServer

    the table sysservers has all the linked servers that have been added;

    select * from sysservers

    with that info, you could do an

    IF NOT EXISTS(SELECT NAME FROM SYSSERVERS WHERE SRVNAME='LINKEDSERVERNAME')

    BEGIN

    --..code...

    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!

    May 27, 2009 at 6:21 pm

    #1001151

  • RE: Create SQL Instance using SMO and VB.Net

    OK I'll ask the obvious:

    if SMO is available, why would you create a separate instance, eating up resources, instead of just adding a database to the existing installation you already...

    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!

    May 27, 2009 at 4:16 pm

    #1001093

Viewing 15 posts - 11,041 through 11,055 (of 13,460 total)