Forum Replies Created

Viewing 15 posts - 376 through 390 (of 13,460 total)

  • RE: Best way to encrypt credit card information?

    AES encryption results in an encrypted string that is still text, so that might require only an enlargement of the field size, and not a data type change.

    I demoed...

    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!

    August 3, 2017 at 7:55 am

    #1953970

  • RE: Read Access to Database Tables - How do you do it in MS-SQL ?

    a public site means you do not know or care who is connecting. you are presenting a limited set of data to the end users.

    so the web page,...

    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!

    August 3, 2017 at 7:04 am

    #1953955

  • RE: SQL 2012 sys databases collation different to instance collation

    there is more script more than just the logins!
    Have you created any server roles(i have a server role to allow read any db for auditors and junior dbas)
    How about 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!

    August 2, 2017 at 1:27 pm

    #1953843

  • RE: No Columns Listed in OLE DB Source Editor Window

    is your source a stored procedure call, or a query?
    a stored procedure call would need SET NOCOUNT ON as, multi statements, like workign with temp tables, affects the way...

    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!

    August 1, 2017 at 3:19 pm

    #1953682

  • RE: CDC capture job waiting for worker thread

    how are you determining that CDC is not capturing changes?
    CDC reads the log asynchronously, but it reads the log, so it cannot really miss any changes, right?
    are 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!

    August 1, 2017 at 11:51 am

    #1953645

  • RE: SQL Logins from 2005 to 2012, but also to new domain.

    sp_help_revlogin works all the way through SQL2016 and beyond, so stick with that, or it's enhanced user-contributed cousin sp_help_revlogin_roles[/url]

    as far as changing domains, if you can guarantee that mydomain\lowell...

    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!

    August 1, 2017 at 7:50 am

    #1953580

  • RE: Postgres SQL

    I don't have a psotgres linked server any more, but the key was how adding or subtracting to a date is different.
    CURRENT_TIMESTAMP and CURRENT_DATE give you GETDATE() or getdate() with no...

    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!

    August 1, 2017 at 6:45 am

    #1953570

  • RE: sys.dm_db_partition_stats.row_count no longer accurate?

    Something additional I'm noticing: for the seven tables that have inaccurate row counts when compared to actual counts,
    Those are tables that are populated with a TSQL MERGE statement from a staging...

    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!

    August 1, 2017 at 6:20 am

    #1953560

  • RE: When does Powershell become indispensible?

    I've had a couple of aha moments, and like Kevin3F noted, it for things that are outside of SQL servers control, but inside the DBA's sphere of responsibility.

    the first big...

    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!

    July 31, 2017 at 2:22 pm

    #1953476

  • RE: Help with SQL Query

    this does what you are asking, I guess:
    this assumes your a ticket is always opened and always closed, and forces an order via the Row_number so i can 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!

    July 31, 2017 at 1:00 pm

    #1953458

  • RE: Presentation Software Recommendations

    no, your post is relevant, no worries.
    Every year, I help with the same style of project I mentioned above, and I ask around before I program something.
    I've already...

    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!

    July 31, 2017 at 12:34 pm

    #1953451

  • RE: Why doesn't this simple concatenation work?

    you are missing the SET statement, it looks like to me.

    Could you try this format instead?
    DECLARE @s_FilePath nvarchar(255) = '' ;
    SET @s_FilePath = '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!

    July 31, 2017 at 12:16 pm

    #1953445

  • RE: Help with SQL Query

    Phils logic looks like it will still work.
    I converted your paste to consumable data

    ;WITH MyCTE([TicketHistoryID],[TicketID],[DateTime],[Name],[TicketActionID],[ID1],[ID2],[TicketStateID],[TicketBoxID],[OwnerID],[PriorityID],[TicketCategoryID],[Myrow])
    AS
    (
    SELECT CONVERT(int,'57440055'),CONVERT(int,'6702938'),CONVERT(datetime,'7/14/17 1:34 PM'),CONVERT(VARCHAR(30),NULL),CONVERT(int,'1'),CONVERT(int,'284'),CONVERT(int,'0'),CONVERT(int,'2'),CONVERT(int,'327'),CONVERT(int,'0'),CONVERT(int,'1'),CONVERT(int,'1'),CONVERT(int,'1') UNION ALL
    SELECT '57440833','6702938','7/14/17...

    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!

    July 31, 2017 at 10:36 am

    #1953425

  • RE: sys.dm_db_partition_stats.row_count no longer accurate?

    OK answering my own question, my assumption was wrong. the count is an approximation. it is not 100% accurate.
    https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql

    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!

    July 31, 2017 at 10:05 am

    #1953419

  • RE: Timeouts Popping Up for Production Database

    with no known changes having occurred, i would update statistics, first, other than burning some CPU cycles, it might fix things that have out of date stats, which could be...

    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!

    July 28, 2017 at 11:37 am

    #1953230

    • Viewing 15 posts - 376 through 390 (of 13,460 total)