Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 13,460 total)

  • RE: convert binary string to table value construct

    Erin i have this saved in my snippets, that will get you 90% there;

    this is enumerating the bits as to wether they are true or false.

    ;WITH myStrings (val)

    AS (

    SELECT '00001001001'...

    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 21, 2014 at 2:56 pm

    #1699247

  • RE: Working with stored text file in TSQL

    a lot more information as far as details would help, but

    if the data is important line by line, then for me, each line should be stored as a row/column in...

    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 21, 2014 at 1:02 pm

    #1699220

  • RE: Help! Get version for each set of rows

    you said "Ignore the Data3 column"

    if i do that, each set you posted are identical, with the exception of the id column, which seems to be incrementing?.

    it seems the only...

    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 21, 2014 at 10:51 am

    #1699190

  • RE: Turn of a Sql server audit trace

    Stubby Bunny (3/21/2014)

    Hi,

    yes, I can see the trace, there is only one going, reading something about a defaut trace that runs on sql server, but whomever set up this server...

    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 21, 2014 at 10:26 am

    #1699182

  • RE: Problem while executing SP from Trigger

    the trigger is always in an implicit transaction.

    if your procedure is trying to update the same table the trigger is on, it will block itself, and can never complete.your proc...

    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 21, 2014 at 7:56 am

    #1699094

  • RE: Help! Get version for each set of rows

    thava (3/20/2014)

    i need to import the data as set with out redundant

    by import, do you mean insert?

    typically i would join the new data against the destination table,and check...

    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 20, 2014 at 11:27 am

    #1698813

  • RE: Database Mail Not working after SQL job completed.

    first, make sure it hit the queue,a dn see if there is an error in the mail logs.

    do you see your email in this select?

    SELECT

    sent_status As Reason,

    err.[description],

    ...

    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 19, 2014 at 2:39 pm

    #1698521

  • RE: Is there an easy way to get the scripts of a table with only t-sql, not with the wizard?

    yep it's possible, but it's not built in.

    using the GUI or via SMO is infinitely easier; I know, because i poured weeks of effort down the TSQL-only method, and it'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!

    March 19, 2014 at 11:22 am

    #1698465

  • RE: How are you adding a semi-colon to existing SQL code when upgrading?

    i've got SQL Enlight for SSMS, which is a static code reviewer, and it identifies all the missing semicolons , along with other best practices for SQL.

    it's not cheap...

    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 19, 2014 at 5:24 am

    #1698325

  • RE: Vertical bars not recognised in source csv

    somewhere in your package, you've got a flat file connection manager.

    if you go to it's details, and go to the columns column, you can change the column delimiter from a...

    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 18, 2014 at 10:53 am

    #1698126

  • RE: How to get sql server ip address

    i would not put too much value in the local ip address; SQL's configured to listen to multiple ip addresses(including 127.0.0.1), and you can review them in the server configuration...

    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 17, 2014 at 6:52 am

    #1697611

  • RE: please give answer to this Interview question

    single table backup is a manual process, which is what the question is testing your knowledge for.

    since you cannot take the application offline, which means you cannot restore the current...

    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 15, 2014 at 12:31 pm

    #1697441

  • RE: Memory leak

    a linked server , when joined against local data, is very slow.

    what actually happens is the entire table from the linked server is copied over into local tempdb, 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!

    March 15, 2014 at 12:28 pm

    #1697440

  • RE: How to pick data from web pages and insert into a sql table

    here's a simple example that returns the html as a varchar(max) I think; note it doesn't download images or anything else on the page.

    'requires

    'Imports System.Net

    ...

    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 15, 2014 at 5:22 am

    #1697404

  • RE: Filtering Extended Events data

    yes you can filter on Database_id or database_name, the same way you could with a server side trace.

    here's a screenshot using 2012's GUI to build an extended event session:

    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 14, 2014 at 2:43 pm

    #1697326

Viewing 15 posts - 2,431 through 2,445 (of 13,460 total)