Forum Replies Created

Viewing 15 posts - 646 through 660 (of 13,460 total)

  • RE: Interview Question

    yeah the items in the article barely merit a nod in acknowledgment , as far as considering them disadvantages.
     i couldn't call any of them show stoppers, or identify 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!

    February 3, 2017 at 3:50 pm

    #1926715

  • RE: Stored Proc not Working after migration - CONTAINSTABLE

    post migration, it's mandatory to rebuild all your indexes ; the statistics are different than the new sql engine expects, andyou'll see poor performance until you rebuild your indexes 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!

    February 3, 2017 at 3:45 pm

    #1926713

  • RE: export to xml file with separate rows

    back in SQL2000 days, there was an undocumented flag DBCC TRACEON(257) that would format xml when sent to text view; you could try that, but I'd bet you need to convert...

    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!

    February 3, 2017 at 10:22 am

    #1926669

  • RE: Best way to determine to Clustered index keys

    Robin35 - Friday, February 3, 2017 7:20 AM

    Chris Harshman - Thursday, February 2, 2017 3:02 PM

    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!

    February 3, 2017 at 8:08 am

    #1926609

  • RE: Interview Question

    i had to google it myself, as my answer would have been to identify the advantages i know of instead...the things i thought of was compiled/faster code,ability to tune, code...

    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!

    February 3, 2017 at 8:01 am

    #1926602

  • RE: Using bcp to export table into .CSV file in TSQL... what in the world am I doing wrong?

    whatever is passed to xp_cmdshell needs to be wrapped in single quotes!
    EXEC master.sys.xp_cmdshell 'bcp "SELECT * FROM MONITORING.dbo.SIZEOUT" queryout D:\DBSizes.csv -c -t, -r \n -T '

    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!

    February 3, 2017 at 6:39 am

    #1926572

  • RE: Grouping by date hour with "buckets"

    helpful consumable format, still working on the solution:

    IF OBJECT_ID('tempdb.[dbo].[#ICA]') IS NOT NULL
    DROP TABLE [dbo].[#ICA]
    GO
    CREATE TABLE [dbo].[#ICA] (
    [MsgDateTime] DATETIME            NULL,
    [UserName]  VARCHAR(255)               NULL,
    [Application] VARCHAR(255)               NULL,

    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!

    February 2, 2017 at 12:52 pm

    #1926447

  • RE: modifying a 'replace' function to use Lower and Upper

    DesNorton - Thursday, February 2, 2017 12:18 PM

    Lowell - Thursday, February 2, 2017 12:10 PM

    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!

    February 2, 2017 at 12:28 pm

    #1926441

  • RE: modifying a 'replace' function to use Lower and Upper

    i think we are just dealing with high ascii here, char 126-255, so switching to nvarchar shouldn't have an impact; i think it's just collation  and case sensitivity.

    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!

    February 2, 2017 at 12:10 pm

    #1926427

  • RE: modifying a 'replace' function to use Lower and Upper

    try this:
    this is explicitly finding the ascii value, and replacing them; it's a modification of a strip high asciii that i had made previously.

    note there are 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!

    February 2, 2017 at 11:58 am

    #1926422

  • RE: modifying a 'replace' function to use Lower and Upper

    your database is case-insensitive, so ?,S,? and s  (four different versions of S)are found in the last replace.

    you want to modify the proc to use binary collation instead

    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!

    February 2, 2017 at 11:09 am

    #1926406

  • RE: Best way to randomly select rows?

    If there was no random requirement, this sounds like a bin packing problem...grab an unknown number of rows until they add up to either exactly $4000, or as close as...

    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!

    February 1, 2017 at 10:20 am

    #1926145

  • RE: (Solved / using SMO) Scripting Definition in sql_modules different from right click > script view.

    as others have identified, the object was renamed with sp_rename.

    OBJECT_DEFINITION and the definition in sql_modules are what is actually saved/stored.

    when you go through the GUI, 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!

    February 1, 2017 at 5:55 am

    #1926043

  • RE: SQL Static Port

    if i try to connect to an explicit wrong port, i'd get a connection timeout error, even if the SQL Browser is running.

    Server=myServerAddress,9999;Database=myDataBase;Trusted_Connection=True;

    TITLE: Connect 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!

    January 31, 2017 at 9:12 am

    #1925890

  • RE: How to find PRIOR line of service? Help plz!

    I'm assuming that your column [START DATE] is what determines the order on a Per Id basis;
    here's soemthing i slapped together, does this get you closer?
    i had 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!

    January 31, 2017 at 9:04 am

    #1925885

Viewing 15 posts - 646 through 660 (of 13,460 total)