SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: tony28

• Parsing out a Data String with Text Delimeters

  Hi All, I'm trying to parse out a line of data that is separated by the text "atc1.", "atc2." etc. …

  evan.gorsky

  2 replies

  11 years, 10 months ago

  By: Luis Cazares

• SQL Join help - 04/11/2014

  Hi all, I am hoping to produce some data based on throughputs, yields etc and I have found t…

  huddythedaddy85

  5 replies

  11 years, 10 months ago

  By: huddythedaddy85

• Automating SQL Server Patching for 10000+ Instances.

  Team, Is there any Best Practice, 3rd Party Tool for Automating SQL Server Patching for around 1000…

  satnam.singh 44358

  5 replies

  11 years, 10 months ago

  By: satnam.singh 44358

• How to bulk insert (or another way) to SQL table from datatabel from inside store prcedure

  I passed .net datatable from a .net app to a store procedure. From this store procedure, how to cod…

  adonetok

  7 replies

  11 years, 10 months ago

  By: Jeff Moden

• Posted from SSIS 2005 Forum, on tight deadline need help.

  I have a SSIS 2005 package that moves .xls files from one directory to and archive folder. This wor…

  Lord Slaagh

  3 replies

  11 years, 10 months ago

  By: aaron.reese