Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 13,460 total)

  • RE: Extracting several rows of information

    not sure how much help this would be.

    the CTE below is just so I have a table that represents the data you provided.

    only the select is the part you'd want...

    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!

    January 31, 2014 at 6:39 am

    #1685034

  • RE: Password checker automation

    Adam i think you just want to do wrap your query as a cte/subselect to get distinct logins with weak passwords, since your new logic allows multiple matches.

    if '0001' 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!

    January 30, 2014 at 9:42 am

    #1684743

  • RE: More then 8000 chars in a column

    change your datatype to varchar(max).

    http://technet.microsoft.com/en-us/library/ms176089.aspx

    max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size is the actual length of the data entered + 2...

    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!

    January 30, 2014 at 6:31 am

    #1684627

  • RE: Password checker automation

    i have this saved in my snippets for auditing weak passwords;

    basically i have a dictionary of known weak passwords to compare against, and also check if the password = loginname.

    hope...

    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!

    January 29, 2014 at 11:51 am

    #1684452

  • RE: Increase trace file retention in SQL 2012

    you are talking about the default trace?

    if that's true, there's no way to modify that built in default trace.

    however, you can script out that same trace,and create a duplicate 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!

    January 29, 2014 at 10:00 am

    #1684394

  • RE: Linked Server query performance

    ok, in that case, the idea is kind of the same...minimize the data you are selecting from the remote server.

    a join to a local tablre, like this:

    FROM Customers T1

    INNER JOIN...

    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!

    January 29, 2014 at 8:53 am

    #1684351

  • RE: Trouble import excel file to SSIS 2012

    can you try explicitly saving the document as excel 2003-2007?

    i've had a similar situation where a csv or html file was saved with an xls extension, so it was not...

    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!

    January 29, 2014 at 7:48 am

    #1684328

  • RE: System database integrity check

    i deprecated my oldstyle maintenance plans in favor of TSQL scripts for the same steps. for example, i really liked Gianluca Sartori's version of capturing only relevant errors from DBCC...

    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!

    January 29, 2014 at 7:37 am

    #1684322

  • RE: Trigger

    Greg Edwards-268690 (1/29/2014)[hr

    Wouldn't an Exception Join (NOT EXSISTS) actually be better?

    Although a real gap could also be record updated.

    Or maybe that never happens. 😀

    Bottom line - spend the time...

    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!

    January 29, 2014 at 7:30 am

    #1684312

  • RE: Linked Server query performance

    balasach82 (1/29/2014)

    We run a delete query which deletes 500-1000 records. But this takes more than 2hours to run.

    We use Linked server between 2 SQL 2008 servers.

    We delete rows...

    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!

    January 29, 2014 at 7:26 am

    #1684310

  • RE: encryption

    column level encryption has been a part of 2005 and above and in all version including express versions, but it's up to your to implement it.

    here's a linky to just...

    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!

    January 29, 2014 at 7:14 am

    #1684304

  • RE: Trigger

    why not just create a procedure that finds what has not been migrated yet?

    either via a join so that it is a perfect match, but probably resource intensive, or by...

    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!

    January 29, 2014 at 6:58 am

    #1684292

  • RE: Avoid KeyLookup

    the key lookup, just by itself, is not a bad thing.

    the query is using the unique index, but has to lookup the other values (due to the SELECT *)

    to 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!

    January 29, 2014 at 6:33 am

    #1684280

  • RE: Need query for comma delimited output

    great job posting sample data! post slike this make me want to help!

    here's an example of a set based operation using a well know technique with FOR XML;

    the STUFF simply...

    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!

    January 29, 2014 at 6:10 am

    #1684268

  • RE: Trigger

    looks like bad logic to me.

    your procedure finds the max id that has a matching criteria, so it assumes a single record was ever inserted.

    if i insert multiple records into...

    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!

    January 29, 2014 at 5:54 am

    #1684264

Viewing 15 posts - 2,596 through 2,610 (of 13,460 total)