SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Varchar(max) length

  Hi, In my sp, i have declared varchar(max), but it taking max 24600 length after that it throwing B…

  PRAMANA.DBA

  6 replies

  11 years, 5 months ago

  By: Sean Pearce

• What account to use for Identity when creating a Credential and to use as the job owner?

  We are running SQL Server 2012 on Windows 2008 Server. I created a credential with a proxy account.…

  HookSQLDBA7

  8 replies

  11 years, 5 months ago

  By: autoexcrement

• good SQL Server dba books

  Hi.I am learning SQL Server in hope to get a job as dba.I'm early in my learning process.I watched …

  asraqfores

  4 replies

  11 years, 5 months ago

  By: Alan Burstein

• CPU Utilization more than 95% for more than 3 hours

  HI Experts, In one of our servers CPU Utilization more than 95% for more than 3 hours, can anyone p…

  VastSQL

  30 replies

  11 years, 5 months ago

  By: Dark Knight

• bulk insert question

  I used code below to do bulk insert. Since csv file first row is column name. How to skip first row…

  adonetok

  4 replies

  11 years, 5 months ago

  By: Jeff Moden

• Create a table

  How to code to create a table in which there are 300 columns and name them as column1, column2...co…

  adonetok

  3 replies

  11 years, 5 months ago

  By: Lynn Pettis

• Translate DATEPART(wk,xx/xx/xxxx) to a non-calendar year-end

  I have read so many articles discussing how best to handle non-Dec fiscal year-ends, etc... using u…

  lduvall

  2 replies

  11 years, 5 months ago

  By: lduvall

• SQL SERVICES ARE MISSING IN CONFIGURATION MANAGER

  hi We have recently migrated SQL2008 to SQL2012 enterprise edition on WINDOWS 2012,and everything i…

  vamsichand999

  2 replies

  11 years, 5 months ago

  By: vamsichand999

• Bulk insert error

  I use code below to upload a csv file to SQL but got an error said that Msg 4860, Level 16, State 1…

  adonetok

  2 replies

  11 years, 5 months ago

  By: adonetok

• Newbie AlwaysOn Questions

  We're refreshing our infrastructure and I want to take advantage of the situation to finally set up…

  Mark Harley

  3 replies

  11 years, 5 months ago

  By: Mark Harley

• Execution plan with many similar missing index messages

  I'm in the process of trying to optimize a stored procedure with many queries. The execution plan …

  rory.well

  3 replies

  11 years, 5 months ago

  By: Grant Fritchey

• Replication - Distribution database doesn't appear under System Databases

  Hi all, i just finished installing SQL Server 2012 with the SQL Server Replication feature componen…

  christy.umoren

  1 replies

  11 years, 5 months ago

  By: BrainDonor

• Store attributes/values in XML column - table design

  Hi experts, I'd like to create a table that will store different order items. Several order items m…

  kiril.lazarov.77

  1 replies

  11 years, 5 months ago

  By: kiril.lazarov.77

• Copy SSRS reports from Dev to Stage to Prod.

  Pardon my ignorance of SSRS. I've never used it before and need to know how to "promote" reports. …

  Jeff Moden

  8 replies

  11 years, 5 months ago

  By: P Jones

• Need recommendations on Replicating(sync a table ) SQL 2012 to SQL 2000 by any means...

  Hi All Please recommend the possible workaround to sync 2 tables from 2012 to 2000. Note: Users …

  Dark Knight

  4 replies

  11 years, 5 months ago

  By: Dark Knight