Forum Replies Created

Viewing 15 posts - 211 through 225 (of 287 total)

  • RE: Data integration/Data transfer

    sql_novice_2007 (6/22/2010)

    we are going to receive 10000 rows per day and each row will have around 19 columns.

    Securoty wise we will be able to receive either by an API call...

    June 22, 2010 at 8:56 am

    #1183393

  • RE: Data integration/Data transfer

    sql_novice_2007 (6/21/2010)

    We need to receive the data from the client on every tuesday.

    We can't access their database server.

    Is there any other way than receiving the data in an excel/csv/txt...

    June 21, 2010 at 4:30 pm

    #1183022

  • RE: Books for SSIS & SSAS

    A couple you could check out:

    Professional Sql Server 2008 Integration Services

    Professional Sql Server Analysis Services 2008 with MDX

    I think both books have Sql 2005 versions.

    June 8, 2010 at 1:27 pm

    #1177652

  • RE: Recreating Foreign Key

    You are not being very clear here.

    When you successfully create it in SSMS, how are you creating it? In an Editor window? via the Designers?

    How are you creating...

    May 24, 2010 at 2:49 pm

    #1171770

  • RE: Regular Expression

    Glad I could help 🙂

    May 22, 2010 at 8:40 am

    #1171220

  • RE: Regular Expression

    nidhivarshney82 (5/20/2010)

    How can we use it in creating search query? Can you give me some examples?

    Assuming:

    1. You are comfortable coding in any one of the .Net Languages.

    2. You have the...

    May 21, 2010 at 3:36 pm

    #1171129

  • RE: Regular Expression

    nidhivarshney82 (5/11/2010)

    Can we write regular expression in sql server express 2005?

    and can we use regular expression in creating search string?

    The short answer is yes. The Sql Clr is available...

    May 20, 2010 at 5:44 pm

    #1170527

  • RE: Issue with Stored Procedure

    What is the Server/Database Collation? It could be a case sensitive one?

    April 15, 2010 at 3:18 pm

    #1152477

  • RE: Installation Problem

    chandrasekaran.ganapathy (4/2/2010)

    While installing SQL Server 2008 I am getting this following error message:

    Unable to connect the SQL server database

    Error details:

    [Microsoft][ODBC SQL Server driver][DBNETLIB]SQL Server does not exist or access denied.

    Please...

    April 2, 2010 at 9:35 am

    #1144867

  • RE: Architecture of dbcc dbreindex and indexdefrag

    Can you let me know the underlying architecture of "dbcc dbreindex" and dbcc indexdefrag". I need the details to understand how the above maintenance queries can boost the performance. Checked...

    March 30, 2010 at 12:20 pm

    #1142550

  • RE: Duration value in a Trace

    You can capture the Execution Plans with Profiler.

    You can look up the "ShowPlan" Events in the Performance Category.

    Try to avoid running Profiler against a Production Server, if you...

    March 30, 2010 at 11:51 am

    #1142514

  • RE: how to use sql sever 2005

    If you just need a Sql Express backend for some C# development then there isn't a great deal to it. Infact, I think the Express Version of Sql Server is...

    March 29, 2010 at 2:22 pm

    #1141713

  • RE: Compatibility Matrix between SQL 2000 and SQL 2008

    Here is a high level one.

    A simple Google search should find you more detailed ones if you choose.

    March 29, 2010 at 2:07 pm

    #1141705

  • RE: URGENT Please help: Queries timeout for about 10 minutes several times a day.

    The dmv, sys.dm_exec_requests can also be helpful in analyzing blocking.

    March 29, 2010 at 1:44 pm

    #1141691

  • RE: alter a table using GUI without having db_owner access

    Is it possible for a user to alter a table using GUI without having db_owner access to that database?

    I believe so, but, you will have to have the appropriate privileges...

    March 29, 2010 at 1:32 pm

    #1141672

Viewing 15 posts - 211 through 225 (of 287 total)