Forum Replies Created

Viewing 15 posts - 5,806 through 5,820 (of 13,460 total)

  • RE: Need a T-SQL Script to create millions of rows

    it depedns on your source.

    if you only have 3 firstnames,3 middlenames and 3 lastnames that is 3x3x3 = 81 unique combinations.in two million rows, that will repeat a lot.

    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!

    March 13, 2012 at 10:28 am

    #1458647

  • RE: Need a T-SQL Script to create millions of rows

    a set based operation will be orders of magnitude faster than c#.

    you need the three base tables, say FNAME,MNAME and LNAME.

    the secret is to cross join the three agasint themselves,...

    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!

    March 13, 2012 at 10:11 am

    #1458625

  • RE: Compare SPs across multiple databases

    Sean Lange (3/12/2012)

    Lowell (3/12/2012)

    ...

    I've got a cute little "Schema Checker" program i wrote that does that for all objects, to help me with identifying versioning/development changes between databases.

    That sounds...

    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!

    March 13, 2012 at 8:01 am

    #1458491

  • RE: Login failedfor user

    "Login failed for user ukk_admin"

    means you connected to the server, so it's gotta be user/login related.

    on the new server, did you CREATE LOGIN ukk_admin ?

    if you restored a copy...

    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!

    March 12, 2012 at 3:31 pm

    #1458214

  • RE: connecting to instance with different server name

    did you try specifying the specific port in the connection string?

    for exmaple, if you changed the dynamic listeninc port below from 1711 (or whatever yours currently is) to port 14330...

    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!

    March 12, 2012 at 3:09 pm

    #1458205

  • RE: localize by country

    we have additional columns in one of our databases, instead of rows.

    so the application ends up displaying the column [descrip_en-us] of , say Row 1 for a product,

    [descrip_fr-FR] for french,...

    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!

    March 12, 2012 at 2:11 pm

    #1458175

  • RE: Compare SPs across multiple databases

    i also have this snippet for stripping comments via TSQL; if you could get that to be an inline function, you'll have it all;

    the onyl way i could think 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!

    March 12, 2012 at 11:16 am

    #1458041

  • RE: Compare SPs across multiple databases

    to do it all in sql, you'd need a CLR for stripping comments out; then it could all be done via TSQL.

    this would be my prototype to start with:

    SELECT *...

    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!

    March 12, 2012 at 11:14 am

    #1458037

  • RE: Compare SPs across multiple databases

    pallvi.pathania (3/12/2012)

    Essentially all the databases are made from a clone so most of them might be exactly same. But I am loooking for incase for any database if there was...

    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!

    March 12, 2012 at 10:43 am

    #1458009

  • RE: Compare SPs across multiple databases

    i do this in a programming language so i can use regular expressions;

    There are two issues to look at...are two procs EXACTLY the same , character for character, or are...

    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!

    March 12, 2012 at 10:17 am

    #1457985

  • RE: Removing alphabetic characters from a query result

    this would ignore colons and am/pm, i think...but it doesn't leave whitespace between a time and am/pm...

    SELECT dbo.StripNonNumeric('Wednesday, 12:14 pm')

    returns "12:14pm",, is that what you want?

    you could get fancier on...

    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!

    March 12, 2012 at 10:10 am

    #1457981

  • RE: rewriting visual basic windows .exe to stored procedure

    also guilty of that 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!

    March 12, 2012 at 9:26 am

    #1457949

  • RE: rewriting visual basic windows .exe to stored procedure

    i've done the same as what you are asking many times...moving data logic out of VB and into stored procs...post the code as an attachment, i'm sure we can give...

    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!

    March 12, 2012 at 9:17 am

    #1457941

  • RE: Removing alphabetic characters from a query result

    ray here is an older Scalar function I have saved;

    If I were doing it today, I'd convert it to an inline tableValue Function, but this would be quick;

    you could also...

    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!

    March 12, 2012 at 8:53 am

    #1457908

  • RE: how to shrink temp db

    haroon.md78 (3/12/2012)

    I can not SQL stop services is that only way to get space back as it is prod server

    Yes. The only way to get the space back is 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!

    March 12, 2012 at 6:51 am

    #1457803

Viewing 15 posts - 5,806 through 5,820 (of 13,460 total)