Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 13,460 total)

  • RE: Need a query to looking for cases of period difference in Legal names

    something like this seems to find matches:

    ;WITH MySampleData([ID],[CompanyName])

    AS

    (

    SELECT '1','All Season Equipment Ltd.' UNION ALL

    SELECT '2','All Season Equipment Ltd' UNION ALL

    SELECT '3','West End Housing, Inc.' UNION ALL

    SELECT '4','West End Housing, Inc'...

    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 9, 2015 at 9:19 am

    #1804000

  • RE: Encrypt SQL server 2014 instance

    When you say "encryption" , do you mean Transparent Data Encryption?

    or row level encryption, which requires each protected column to have data type changes, and encryption and decryption routines...

    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 8, 2015 at 12:18 pm

    #1803774

  • RE: Create DB, Add Data Only

    when you copy pieces, it's so easy to overlook something that was required.

    there's always one mor ething that got overlooked, and turns into a constant trickle of research.

    i lean...

    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 8, 2015 at 9:58 am

    #1803737

  • RE: Restore Sequence

    info.sqldbamail (6/8/2015)

    Thank You

    I get your point : 1 FULL Backup + Most Recent Diff Backup + All Cumulative log backups since Last full backup is this correct.

    No, that's not right.

    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!

    June 8, 2015 at 7:14 am

    #1803658

  • RE: Restore Sequence

    log backups are cumulative, and are not affected by differential, so you cannot go from full + diffs + one last log. it's an either log-or-differential process.

    full backup, plus any...

    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 8, 2015 at 6:53 am

    #1803644

  • RE: json into sql server

    JeeTee (11/6/2014)

    Depending on what's in between ElasticSearch and SQL, a rudimentary .Net application can quite easily de-serialize the JSON before putting it into SQL.

    exactly how i do it myself.

    Also, there's...

    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 4, 2015 at 9:30 am

    #1803056

  • RE: incement by 5 starting at 5

    I think row_number is they way to go here; then you cna just multiply it by five.

    WITH CTE as

    (

    SELECT row_number() over(order by MyPrimarykey) * 5 as myColumn from table

    )

    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!

    June 4, 2015 at 9:26 am

    #1803051

  • RE: please help us to improve this query performance level without affecting the existing functionality

    mohanaprabhu.v (6/4/2015)

    SELECT tblInvoice.*, tblCustomer.FirstName + SPACE(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!

    June 4, 2015 at 6:48 am

    #1802962

  • RE: Access SQL instance without sa password

    lduvall (6/3/2015)

    I've reached out to the "wing" of the company that might tell me if they have disabled my predecessor's account & could temporarily re-instate it so that I could...

    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 3, 2015 at 3:14 pm

    #1802817

  • RE: Access SQL instance without sa password

    same thing then, right?

    if he is a local admin on the PC in question, he can run the script and take over the SQL instance(s).

    if he had 3 instances(ie...

    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 3, 2015 at 1:57 pm

    #1802797

  • RE: Access SQL instance without sa password

    if you can rdp or login directly to the server, then you could stop and start the service in sinlge user mode, regardless of whether you are a sysadmin 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!

    June 3, 2015 at 1:07 pm

    #1802790

  • RE: Managing Hight Qty of SQL Servers By Client

    are you familiar with SSMS's Registered Servers or Central Management servers?

    it does exactly what you seem to be asking, and it's built in.

    once you add them in a hierarchy, 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!

    June 3, 2015 at 12:54 pm

    #1802781

  • RE: Syntax to convert from ounces to pounds in format of 6 lb 3 oz

    help us help you!

    CREATE TABLE and sample data get you help fast!

    i put this example together that might help you visualize it.

    i got the formula for ounces to grams 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!

    June 3, 2015 at 5:40 am

    #1802558

  • RE: Sql server Named Instance

    Joie Andrew (6/3/2015)

    In SQL Server Management Studio view "Registered Servers". Create a folder for your 10 instances and register each server instance. Once all 10 are added right-click on 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!

    June 3, 2015 at 5:11 am

    #1802550

  • RE: Recover database value

    Confirming what Gianluca said, no backup = no restore.

    contact your web host directly and immediately, though.

    if you are lucky, your host might be doing backups automatically on your...

    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 3, 2015 at 5:07 am

    #1802549

Viewing 15 posts - 1,711 through 1,725 (of 13,460 total)