Forum Replies Created

Viewing 15 posts - 811 through 825 (of 2,894 total)

  • RE: pages

    ramyours2003 (11/29/2012)

    HOW MANY datapages in sql ?

    Sean Lange (11/29/2012)

    Everybody knows this is 42 😛

    No, you're wrong, they changed it! It's 321 since Thanksgiving!

    :w00t:

    They may cut it back to 238, there...

    November 30, 2012 at 4:45 am

    #1564280

  • RE: How to pass parameter from console to .rpt report ?

    Joy Smith San (11/30/2012)

    Experts,

    I have a report made using SSRS 2008. This report is called from Symantec Altiris console.

    (It's nothing but an ASP.dotnet application from Symantec). Requirement is that this...

    November 30, 2012 at 4:38 am

    #1564276

  • RE: Architecture Diagram

    karthik M (11/29/2012)

    All,

    I need the of "Architecture Diagram" SQL 2012 & SQL 2008. I am tired to get the diagram from google. I can see features, merits, demerits, unsupported functionalities...

    November 30, 2012 at 4:18 am

    #1564262

  • RE: Identify objects in all the databases which are using specific column as the filter (where condition)

    I need to identify all the database objects (Stored Procedures, functions,views etc) which are using a specific column called RegulatoryTypes only in the filter (where condition).

    In short - It...

    November 30, 2012 at 4:12 am

    #1564259

  • RE: Regarding sql server 2005

    boobalanmca07 (11/29/2012)

    what are the concepts should know in sql server 2005

    First and the main one: concepts of Relational Databases.

    November 30, 2012 at 4:08 am

    #1564256

  • RE: Why the server are running to slow?

    Shadab Shah (11/30/2012)

    This has being a common observation since last few days. The server through which i am connected is taking long time to respond like long time to execute...

    November 30, 2012 at 4:01 am

    #1564252

  • RE: Search a string from multiple column in a table

    Dave Ballantyne (11/30/2012)

    Three seeks here,

    Anyway the point is that the optimzer is now able to choose between a seek and scan not the developer 🙂

    Cannot see the image you've attached,...

    November 30, 2012 at 3:59 am

    #1564248

  • RE: Help with XQUERY

    Jonathan Mallia (11/30/2012)

    Hi Eugene,

    How can I escape the special characters (<, >, &) in XQUERY and successfully parse the XML ? The unfortunate thing is that I cannot ask the...

    November 30, 2012 at 3:57 am

    #1564245

  • RE: QUERY OPTIMISATION AS IT TAKES MORE THAN ONE MINUTE TO FETCH THE RECORDS

    There are few changes you may try, please note my comments:

    create PROCEDURE [dbo].[ABC]

    (

    @user-id as varchar(7),

    @LoginType as varchar(5),

    @AccType varchar(3),

    @AccountActive varchar(1),

    @SFAClientType varchar(20),

    @TIDM varchar(7),

    @SEDOL varchar(7),

    @responsibilityCode varchar(7),

    @pageNumber int,

    @pageSize int,

    @sortExpression varchar(32),

    @sortOrder varchar(4),

    @virtualCount int OUTPUT

    )

    WITH RECOMPILE

    AS

    BEGIN

    ...

    November 30, 2012 at 3:35 am

    #1564239

  • RE: Help with XQUERY

    & (and some other) characters in XML needs to be escaped (eg. & for &).

    Otherwise, any XML parser will reject it as not well-formed XML...

    November 30, 2012 at 3:04 am

    #1564236

  • RE: Search a string from multiple column in a table

    Dave Ballantyne (11/29/2012)

    dilipd006 (11/29/2012)

    Eugene Elutin (11/29/2012)

    Try this:

    SELECT S.CityId, C.Name

    FROM @City AS S

    CROSS APPLY (VALUES (CityName),(AlternateCityName1),(AlternateCityName2)) C(Name)

    WHERE C.Name LIKE @SearchString + '%'

    Thanks Eugene..never known we can use Cross Apply...

    November 30, 2012 at 2:55 am

    #1564232

  • RE: Datawarehouse architecture for Banking Project

    duplicated...

    November 30, 2012 at 2:29 am

    #1564223

  • RE: Datawarehouse architecture for Banking Project

    sagar0838 (11/30/2012)

    Can anyone please tell me what will be datawarehouse architecture for a banking project ((ex>

    facts and dimensions,kind of sources available,security measures to be taken etc

    That what people (including myself)...

    November 30, 2012 at 2:27 am

    #1564222

  • RE: Exercises in t-SQL

    The key in my suggestion of Google wasn't really - find everything on internet, but:

    expert can spot common problems and find ready-to-use solution in a matter of seconds

    That would count...

    November 29, 2012 at 1:39 pm

    #1564019

  • RE: Search a string from multiple column in a table

    vikingDBA (11/29/2012)

    Don't know if this is exactly what you are wanting, but I wrote this to search all tables for occurance of given string. ...

    Don't you think it's a bit...

    November 29, 2012 at 10:20 am

    #1563918

Viewing 15 posts - 811 through 825 (of 2,894 total)