SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Is Shrinking Log Files Good or Bad?

  We are faced with shortage of drive space and the majority of the space is taken up by very large l…

  scantoria

  12 replies

  11 years, 5 months ago

  By: Perry Whittle

• Backup and Restoration Time Issue

  I have two databases say A and B in two different production servers. Weekly once we take full back…

  balasaukri

  8 replies

  11 years, 5 months ago

  By: balasaukri

• sys.dm_exec_procedure_stats possible incorrect results

  Does anyone know of any know issue w/ sys.dm_exec_procedure_stats I've got as process to store the …

  Snargables

  9 replies

  11 years, 5 months ago

  By: Jack Corbett

• Query becoming slower when records are retrieved..how to make it faster

  Dear all Following is my db table student_id student_code student_parent_id student_name …

  peterausger

  7 replies

  11 years, 5 months ago

  By: Jeff Moden

• Loop

  Hi, I am trying to parse data separated through text (ie abc1, abc2, abc3, abc4, etc). ID Pa…

  newface

  1 replies

  11 years, 5 months ago

  By: Luis Cazares

• AVG(DateDiff) in one line?

  I am trying to pull a report with average down time and I getting the error message "Msg 195, Level…

  jennigirl

  3 replies

  11 years, 5 months ago

  By: Luis Cazares

• Gathering Baseline Statistics

  Hi I just listened to Brent Ozar's video on this and the video is from 2009 so not sure if there a…

  plamannkathy

  3 replies

  11 years, 5 months ago

  By: Igor Micev

• Error: 17806, Severity: 20, State: 14 when a domain controller reboots

  When we reboot one of our domain controllers(not sure which one yet) we receive a flow of these err…

  piebri

  1 replies

  11 years, 5 months ago

  By: Maddave

• Who decides to allocate indexes onto pages? Storage Engine Or Query Processor?

  Hi All, Through the SQL Server, Let me know, How Indexes are allocates on pages? And If a CREATE IN…

  Thinky Night

  4 replies

  11 years, 5 months ago

  By: Thinky Night

• Fusion-IO drive and mdb files

  We have a cluster with two nodes and two instances of SQL Server 2012 Standard Edition running on t…

  Colossus

  3 replies

  11 years, 5 months ago

  By: Colossus

• Strategies to archive old database data

  Hi! I have the requirement to implement archiving of some database old data. The database is not us…

  amns

  3 replies

  11 years, 5 months ago

  By: amns

• please help to create a sql statement.

  Hi Could you please help to create a sql statement on below requirement I have data like below CREA…

  sushil_dwid

  2 replies

  11 years, 5 months ago

  By: sushil_dwid

• Moved the backups to the fileshare but I can't restore directly from the fileshare

  Hi All We had our backups backing up to the server where the databases reside. Now I modified the b…

  plamannkathy

  11 replies

  11 years, 5 months ago

  By: Maddave

• Partitioning problem

  Hello, I did partitioning for my table, for testing I choose table about 3mil rows from 2008-2014 …

  tony28

  3 replies

  11 years, 5 months ago

  By: tony28

• separate or one database ?

  what is better what do you think ? I am thinking about our database desing separate db according to…

  tony28

  4 replies

  11 years, 5 months ago

  By: tony28