Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 15,381 total)

  • RE: Error with application side

    Aatish Patel (9/9/2015)

    Hi, any idea on the below error..

    Login failed for user 'IHS\test_user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 102.21.48.258]

    the login...

    September 9, 2015 at 8:14 am

    #1825407

  • RE: 'Where' conditions

    eccentricDBA (9/8/2015)

    SQLAddict01 (9/8/2015)

    I have so many NOT IN conditions like ::

    Select * from backups

    where

    databasename not in (select databasename from backups where...

    September 8, 2015 at 3:27 pm

    #1825282

  • RE: session hang and resource issues(CPU/memory wait) when trying to do a big work load

    ying.wang (9/8/2015)

    Hello,

    We have some issues in our sql server 2012 SP1 system. when trying to move a big folders from application which is a document management application , the system...

    September 8, 2015 at 3:25 pm

    #1825281

  • RE: Parameter conversion

    aleksandra 81219 (9/8/2015)

    But I said also many times that i cant execute procedure with these parameters! This is not a problem with splitting dates! I can split dates inside the...

    September 8, 2015 at 7:56 am

    #1825140

  • RE: Query to bring through today's values only

    faulknerwilliam2 (9/8/2015)

    Hello

    I have a query where:

    WHERE a.jobdate >=GETDATE()-1

    This brings though data from today and yesterday; I understand this is because GETDATE = now.

    However, all I want is to see is...

    September 8, 2015 at 7:49 am

    #1825134

  • RE: Parameter conversion

    aleksandra 81219 (9/8/2015)

    So please tell how to use this function to make from 3 strings only one string which I could pass to procedure and execute it somehow 😉

    You have:...

    September 8, 2015 at 7:33 am

    #1825124

  • RE: Parameter conversion

    aleksandra 81219 (9/7/2015)

    Part with dates is totally fixed. Its always list of separate dates: 'date1','date2','date3',... because these dates are passed by a parameter. For example @dates. I cant modify...

    September 8, 2015 at 7:15 am

    #1825111

  • RE: First Occurance of the string from text

    Hi and welcome to SSC. Your post doesn't make any sense at all. What is the logic here and how do you know you want to find that particular string...

    September 4, 2015 at 2:27 pm

    #1824781

  • RE: What Kind of DBA Are You?

    webrunner (9/4/2015)

    Sean Lange (9/2/2015)

    Luis Cazares (9/2/2015)

    Sean Lange (9/2/2015)

    BrainDonor (9/1/2015)

    What's the difference between 'None of the above' and 'Other'?

    Also curious what is the difference between "Development" and "Development DBA".

    I understand it...

    September 4, 2015 at 2:23 pm

    #1824779

  • RE: hi, i'm a noob on sql 2008 could anyone suggest me on how to do it

    The biggest challenge you are going to have here is getting reliable data back out. This is because your data is not normalized. This should be at least three tables...

    September 4, 2015 at 12:18 pm

    #1824757

  • RE: Create dates right on the hour interval-best technique

    mar.ko (9/4/2015)

    Sorry guys, my bad....definitely having a bad day.

    And DateAdd is probably efficient....as whenever strings are involved, the conversion is usually costly.

    Lowell's solution is very slick and efficient.

    Sean's solution is...

    September 4, 2015 at 12:13 pm

    #1824755

  • RE: Create dates right on the hour interval-best technique

    mar.ko (9/4/2015)

    Sean Lange (9/4/2015)

    mar.ko (9/4/2015)

    I tried this:

    SELECT Convert(smalldatetime,Round(Convert(float,(dbo.fnDateOnly(getDate())))+16.0000000/24.0000000,6))

    Result: 2015-09-04 16:00:00

    It works (FnDateOnly strips the time).

    Is there a more efficient way ?

    What are you trying to do? And what is fnDateOnly?

    RTFM:...

    September 4, 2015 at 8:32 am

    #1824690

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/4/2015)

    Brandie Tarvin (9/4/2015)

    I just came up with the great "customer friendly" metaphor for table contention.

    One business unit wants to know why production report X was timing out, so...

    September 4, 2015 at 8:01 am

    #1824665

  • RE: UDB DBA -- needs to learn sql server db

    anshul.modi85 (9/4/2015)

    Team ,

    I have 9 years of experience in DB2 UDB and now I want to add my skillset and want to learn sql server dba.

    Please share the guide or...

    September 4, 2015 at 8:00 am

    #1824664

  • RE: Create dates right on the hour interval-best technique

    mar.ko (9/4/2015)

    I tried this:

    SELECT Convert(smalldatetime,Round(Convert(float,(dbo.fnDateOnly(getDate())))+16.0000000/24.0000000,6))

    Result: 2015-09-04 16:00:00

    It works (FnDateOnly strips the time).

    Is there a more efficient way ?

    What are you trying to do? And what is fnDateOnly?

    September 4, 2015 at 7:52 am

    #1824656

Viewing 15 posts - 2,371 through 2,385 (of 15,381 total)