Forum Replies Created

Viewing 15 posts - 796 through 810 (of 3,061 total)

  • RE: Poll - "SQL Server Administrator"

    This is a large organization, isn't it?

    Personally I'm comfortable with letting Sysadmins to take care of the platform all the way to the O/S level.

    In regards to RDBMS installation and...

    October 27, 2011 at 11:23 am

    #1400307

  • RE: Replication or something else?

    jared-709193 (10/27/2011)

    Scenario:

    Application may be routed to 1 of 4 servers depending on load and location: Colorado, Michigan, 2 Illinois. Data from each server needs to be replicated to 1 reporting...

    October 27, 2011 at 11:18 am

    #1400304

  • RE: Please Help !!!!

    sqldba2k8 (10/15/2011)

    I was completed my sql server dba course in one of the worst institute in hyderabad.

    Trust me - you really don't want this statement to be public and available...

    October 27, 2011 at 9:57 am

    #1400265

  • RE: self teaching newbie needs help please...

    GSquared (10/27/2011)

    You can do your original idea. It's a really bad idea, but it can be done.

    Agreed. Politicians follow that very same principle in a daily basis 🙂

    October 27, 2011 at 9:46 am

    #1400256

  • RE: database size

    pavithrareddyc (10/20/2011)

    not looking for the script to know the size of the data base. but i just want to know in general what would be the size of the data...

    October 27, 2011 at 9:41 am

    #1400251

  • RE: PLease help with a count problem

    Are you getting syntax error? Check predicate syntax.

    October 27, 2011 at 9:17 am

    #1400234

  • RE: how can i get a table to go inside another table

    danmc58 (9/14/2011)

    i have a table (1) that i imported in DTS, just one column varchar 255 (name) about 400k records

    i have another table (2) that has 4 columns, the one...

    October 27, 2011 at 7:22 am

    #1400132

  • RE: SSRS question !

    abcuser (10/25/2011)

    My questions is how do i decide when to use multiple datasets and where to use them ?

    How about taking into consideration the Business Requirements?

    October 27, 2011 at 7:19 am

    #1400127

  • RE: Database Naming

    Ruprecht (10/21/2011)

    I'm trying to come up with a name for a database and I'm stumped. This database is going to be the repository for a bunch of small applications...

    October 27, 2011 at 7:16 am

    #1400124

  • RE: Smoothest way to go about this...

    David Lester (10/26/2011)

    I have a warehouse where there is a product code field, and this is 99% of the time queried for a single product code, which matches to a...

    October 27, 2011 at 7:00 am

    #1400118

  • RE: self teaching newbie needs help please...

    ajk825 (10/25/2011)

    I want the MaterialsNeeded column to be able to be multplie rows for the same project in the datatable...Is it possible?

    This is what we call a "one-to-many relationship" and...

    October 27, 2011 at 6:51 am

    #1400113

  • RE: Best practices for granular access to production databases for non-DBA users

    praveen_vejandla (10/10/2011)

    Hi,

    We would like to streamline access to production SQL Servers such that non-DBA users will not have sysadmin privileges but they should still be able to do regular operations...

    October 10, 2011 at 5:18 am

    #1392331

  • RE: Is Clusterd Index sort and store data in physical order in table?

    sqlzealot-81 (10/10/2011)

    There is no gurantee for this...

    :w00t: Could you elaborate, please?

    October 10, 2011 at 5:16 am

    #1392330

  • RE: Optimal size for a tempdb in production environment

    Jeff Moden (10/9/2011)

    Gail Shaw and Paul Randall might disagree with both of us, Steve... something about the underlying allocation units and all that. But, I think they also might...

    October 9, 2011 at 7:21 am

    #1392183

  • RE: Partitioning

    Lexa (10/8/2011)

    I've an Items table partitioned on item_id, which is also a primary key and clustered index. The partitioning scheme puts 500K of item_ids per partition. For reretrieval...

    October 9, 2011 at 7:13 am

    #1392182

Viewing 15 posts - 796 through 810 (of 3,061 total)