Administering

• Topics

  Started by

  Posts

  Last post

• query running 15hrs for 1lakh records

  Hi The below query is running in my production server.As u can understand the query fetching the re…

  cnu1252

  3 replies

  10 years, 11 months ago

  By: ChrisM@Work

• xml path comma separated values in sql query

  Hi This is my first time to post my complex query here I am facing the critical problem for comma s…

  cnu1252

  3 replies

  10 years, 11 months ago

  By: cnu1252

• CPU Utilization maxes out

  Hi all, I have a problem that I'm having a difficult time trying to solve. Basically, every Sunday …

  kramaswamy

  2 replies

  10 years, 11 months ago

  By: kramaswamy

• Taking More Time to execute then the previous

  HI, I'm working in DWH environment Every day many data gets extracted transformed & loaded But…

  santoshkal

  1 replies

  10 years, 11 months ago

  By: Gail Shaw

• sync Databases to secondary server which is used for Read-only

  Hiiiiii I want to sync Databases to secondary server which is used for Read-only for SSRS purpose, …

  sql.lanka

  4 replies

  10 years, 12 months ago

  By: sql.lanka

• Setting up Prod and Dev servers

  Hi all This is probably going to be a long-winded post, but I'll keep it as brief as possible. Here…

  richardmgreen1

  6 replies

  10 years, 12 months ago

  By: richardmgreen1

• Please resolve error message "Not a valid login"

  I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I …

  enriquemallon

  1 replies

  10 years, 12 months ago

  By: Eirikur Eiriksson

• Query to find maxdop of an index

  Hello, I altered index with maxdop to somevalue (n). What is the query to validate that xyz index h…

  pawana.paul

  3 replies

  10 years, 12 months ago

  By: pawana.paul

• Reindex - does it make data contiguous, space permitting

  I have a large database with several very large files in the Primary file group. I am moving 90+ p…

  Tom John-342103

  4 replies

  10 years, 12 months ago

  By: Tom John-342103

• Reorganize Files Before Releasing Unused Space

  We have a database that we want to shrink. I understand that checking the box to Reorganize files …

  Roger Abram

  4 replies

  11 years ago

  By: Welsh Corgi

• Login failed for user 'NT AUTHORITY\SYSTEM'

  I get hundreds of these messages in my SQL Server logs every day. The messages have a sev 14 and a …

  barryFS

  8 replies

  11 years ago

  By: jai.chaturvedi88

• sp_xp_cmdshell_proxy_account who has been granted to use it?

  Hi, we enabled xp_commandshell Proxi Account on SQL 2008 R2 and use it succesfully with two users. …

  w.oldoerp

  5 replies

  11 years ago

  By: w.oldoerp

• What's the best way to change the 'sa' password

  Hi everybody, I'm new at the company and my boss is asking me to change the 'sa' password because t…

  Willian Funes

  12 replies

  11 years ago

  By: Mike Hinds

• data file for tempdb very huge

  hi all, Our data files for tempdb is simply growing out of proportion. Currently the size of tempd…

  sharon-644450

  7 replies

  11 years ago

  By: ali_sha61-729669

• Why the TUF file will not create?

  Hi All, I have a Question? Why the TUF file will not create when we configure the Logshipping in NO…

  Chowdary's

  4 replies

  11 years ago

  By: Chowdary's