Forum Replies Created

Viewing 15 posts - 9,616 through 9,630 (of 13,460 total)

  • RE: how to move the table to another drive with out taking them to offline?

    Krisn (4/26/2010)

    Hi all,

    could you please let me know how to move the table to another drive with out taking them to offline in sql 2k?

    thanks in advance,

    regards,

    Kris

    Kris if you alter...

    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!

    April 26, 2010 at 8:16 am

    #1157639

  • RE: Execution plan SQL 2008

    dtipser (4/26/2010)

    Hi,

    Yes, I created the index, but after that is asking to create another one. For sure the statement run a litle faster but it still doing some scans in...

    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!

    April 26, 2010 at 6:55 am

    #1157572

  • RE: How To Send Message To All Connected User On Insert In A Table

    Developer 2005 (4/26/2010)

    Thanks

    u are right

    but we don't want to send mail to all user.

    i want to pass a message in message box and want to display on screen of...

    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!

    April 26, 2010 at 6:14 am

    #1157552

  • RE: PLEASE HELP !!!!

    search your MSSQL.1mMSSQL.2 and MSSQL.3 folders for *.mdf files.

    with luck, one of those files should be the name of your old database.

    once it, you will copy that MDF file along...

    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!

    April 24, 2010 at 5:53 am

    #1157252

  • RE: sysobjects tables that don't exists in database

    hansel i'm not sure what you are doing...

    sysobjects in SLQ 2000 contains the metadata of all the objects in the database, including the tables; you can join sysobjects to syscolumns...

    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!

    April 23, 2010 at 4:43 pm

    #1157169

  • RE: Limiting view to only work when called from a stored procedure

    i actually can see how that is a good idea; some views pulling together a lot of stuff shouldn't be ad hoc queried;

    I like the idea.

    i might actually rename some...

    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!

    April 23, 2010 at 10:44 am

    #1157022

  • RE: Converting to DateTime

    Oleg good catch! that's the diff between using datepart and calculating elapsed time; i'm fiddling with it now of to test for accuracy;

    Thanks!

    ::edited; i think this seems to calculate...

    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!

    April 23, 2010 at 10:14 am

    #1157007

  • RE: Execution plan SQL 2008

    well the optimizer uses the stats to determine the fastest way to get the data; if the statistics imply that the selectivity of a record is very close to 1...

    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!

    April 23, 2010 at 9:27 am

    #1156964

  • RE: Converting to DateTime

    now that you have the two vals as datetime, it should be easy;

    here's some examples i've saved that pulls out the peices; you can concat them togeter for the format...

    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!

    April 23, 2010 at 9:03 am

    #1156937

  • RE: Execution plan SQL 2008

    statistics.

    the statistics are different between the two databases.

    even if the two db's started out as identical, the way the data is selected/updated can change the statistics, and THAT is what...

    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!

    April 23, 2010 at 8:44 am

    #1156910

  • RE: Case statement in SQL

    this one is just a basic error, no worries.

    the issue is this part i think:

    WHERE EMP_ID = ''' + @ZEMP_ID + ''''

    you are doing VARCHAR + INT, which results in...

    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!

    April 23, 2010 at 6:30 am

    #1156766

  • RE: invalid objects

    procs and functions are going to be the same logic; cursor with a try - catch, but instead a dynamic SQL;

    get the text for the proc/function from sys.sql_modules, do...

    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!

    April 23, 2010 at 5:08 am

    #1156711

  • RE: invalid objects

    I had looked into this same issue back in september;

    see this thread here:

    http://www.sqlservercentral.com/Forums/Topic785213-146-1.aspx

    at the time, i was having some developers run scripts that dropped stuff, and then they found 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!

    April 22, 2010 at 5:50 pm

    #1156529

  • RE: Creating a SQL 2008 synonym to named instance

    do a select * from sys.servers

    quite often, the alias for your linked server is different than the name of the actual server.

    it's the name of the linkedserver, not the...

    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!

    April 22, 2010 at 4:11 pm

    #1156506

  • RE: ROW_NUMBER() - Using it More then Once In A query

    yeah i've used multiples before; i needed both a counter and a partitioning /grouping of the data;

    here's a simple but lame example:

    select

    Row_number()...

    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!

    April 22, 2010 at 12:02 pm

    #1156350

Viewing 15 posts - 9,616 through 9,630 (of 13,460 total)