Forum Replies Created

Viewing 15 posts - 10,411 through 10,425 (of 13,460 total)

  • RE: Get index scan on zip code radius query - not sure why.. ! ?

    an index scan is not really a bad thing; much better than a table scan.

    I think it depends on the selectivity of the index in question as to whether 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!

    October 19, 2009 at 7:10 pm

    #1067887

  • RE: Get DDL for any SQL 2005 table

    ok I was playing with this today and found that i somehow broke the code for an computed columns;

    I fixed and tested the solution, and here we go again:

    here is...

    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!

    October 19, 2009 at 12:48 pm

    #1067803

  • RE: avoiding RBAR using a split function against a table of values

    ahh;

    thanks Dave; That got me jump started so i could make a 1-to-many table that i was fishing for.

    Thank you again!

    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!

    October 19, 2009 at 7:58 am

    #1067639

  • RE: Who Deleted the Records ?

    the default trace only shows DDL statements...create table/proc/alter/drop, for example.

    you need a separate trace running for DML statments like select/insert/update/delete.

    log reader like apex is the way to go here.

    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!

    October 16, 2009 at 3:52 pm

    #1067253

  • RE: Create a database on a remote SQL Server

    i may be wrong, but i thought a linked server only allows DML (data manipulation and no DDL; you can't create a temp table, nor use the "SELECT... INTO NewTable...FROM"...

    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!

    October 16, 2009 at 11:57 am

    #1067085

  • RE: Get DDL for any SQL 2005 table

    Elliot thanks, I'm looking at it now, if i get it to work i'll add another version;

    sarodude, thanks! i had it working, then was trying to find the right column...

    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!

    October 14, 2009 at 3:58 pm

    #1066027

  • RE: Need to Calcualate 4 quarters from a given date

    the trick is to use the datediff and date add functions

    for example here's how to find the first day of "this" quarter, ,and the previous 4 quarters based on today:

    --First...

    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!

    October 14, 2009 at 12:17 pm

    #1065900

  • RE: "Active Threads"

    i've got a couple of questions related to the same issue.

    what is the definition of "Recent Posts>>Posts Added Today"

    i just replyed to a post from 5 days ago, and it...

    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!

    October 14, 2009 at 11:53 am

    #1065885

  • RE: Create an 'Insert Into' statement with schema and data from existing table.. possible?

    glad i could help sam; let me know if this wroks out for 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!

    October 14, 2009 at 11:46 am

    #1065880

  • RE: Pls Help ....Script to List the Database Objects With Specific Keyword

    you posted in a SQL 2005 forum, so you got 2005-specific examples.

    it's not object_name that is stopping your script...it's sys.columns:

    SELECT OBJECT_NAME(id) from syscolumns where name ='ORDERID'

    will work in 2000

    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!

    October 14, 2009 at 8:23 am

    #1065713

  • RE: Pls Help ....Script to List the Database Objects With Specific Keyword

    John Paul-702936 (10/14/2009)

    Thanks ..

    If you don't mind .. Can you tell me

    Script to List of the Objects that uses a Specific Column name

    aain, you'd use 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!

    October 14, 2009 at 8:12 am

    #1065704

  • RE: Pls Help ....Script to List the Database Objects With Specific Keyword

    all objects are in the system view sys.objects

    so you'd simply do SELECT * FROM sys.objects where name like'%BIZ%' for example.

    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!

    October 14, 2009 at 7:58 am

    #1065683

  • RE: Get DDL for any SQL 2005 table

    Nathan thanks for the feedback; having a different pair of eyes helps so much shaking down a proc like this.

    #2 and #3 on the list of the things you identified...

    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!

    October 13, 2009 at 4:55 pm

    #1065446

  • RE: SP to copy data from view to a new table in SQL Server 2008

    davidlcrooks (10/13/2009)

    Sorry for the lack of details. You are close.

    I have a view with some data.

    I want to create an empty table with the same structure...

    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!

    October 13, 2009 at 8:53 am

    #1065234

  • RE: SP to copy data from view to a new table in SQL Server 2008

    little too thin on the details to offer any help so far;

    what does the filename have to do with anything?

    I'm trying to read between the lines, so help me 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!

    October 12, 2009 at 8:06 pm

    #1065003

Viewing 15 posts - 10,411 through 10,425 (of 13,460 total)