SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• tsql for XML format the values as elements

  I am trying to get the values in a column as XML elements. Is it possible to do this using For XML …

  isingh

  5 replies

  12 years, 7 months ago

  By: isingh

• SSRS report with custom filename and tab name for email delivery subscription

  Hi, I have a report and its name is MonthlyReport and I run it for 20 diff states(PA,NJ,DE,MA,CT et…

  sql_novice_2007

  3 replies

  12 years, 7 months ago

  By: Jason Selburg

• How to handle an accidently dropped object or deleted rows?

  We have SQL Server 2012 running on Windows Server 2008. In Oracle, if a table is accidently dropped…

  HookSQLDBA7

  3 replies

  12 years, 7 months ago

  By: manik_anu

• sparse column

  Dear All Want to check the differnce in table size for sparse and normal column. Following code use…

  Krishna1

  3 replies

  12 years, 7 months ago

  By: Krishna1

• Scheduling SSIS Packages with something other than SQL Server Integration Services

  Right now I have a third party tool that takes the DTSX package, allows me to schedule it, and show…

  SQL_Enthusiast

  1 replies

  12 years, 7 months ago

  By: Koen Verbeeck

• SSIS SharePointList Adapters with Visual Studio/SQL Server 2012 - Destination Connector Error

  Has anyone successfully used the newest SharePointList Adapters for 2012 at SharePointListAdapters…

  Larry Schmidt-491187

  1 replies

  12 years, 7 months ago

  By: Larry Schmidt-491187

• Just installed SQL Express and...

  I'm looking for some direction. I did it because I'm reading The Accidental DBA in an effort to br…

  sqldriver

  10 replies

  12 years, 7 months ago

  By: Jeff Atherton

• How to install SQL Server Data Tools and Visual Studio?

  We are running SQL Server 2012 SP1 Enterprise Edition on Windows Server 2008 R2 Enterprise SP1. We …

  HookSQLDBA7

  1 replies

  12 years, 7 months ago

  By: e4d4

• Run SSIS Package from .Net

  I've read several posts and blogs on the subject. I think I have a strategy. Here's how I came by i…

  Jim

  3 replies

  12 years, 7 months ago

  By: Koen Verbeeck

• copying data tables between database and keeping indexes and identity columns

  Is there a way to copy tables between databases (ssis?) and keep the identity columns and indexes o…

  timscronin

  5 replies

  12 years, 7 months ago

  By: Koen Verbeeck

• SQL 2012 - Updating a field based on Row to Row Comparison

  I have a table that contains dates and times. For example fields are Date, ExTime, NewTime, Status.…

  drknight88

  6 replies

  12 years, 7 months ago

  By: Dwain Camps

• Flat File Input Field Lengths

  I have a tab-separated-value (TSV) input file for my SSIS package. When I point to the file to crea…

  Jim

  2 replies

  12 years, 7 months ago

  By: Jim

• Linked Server error 7357

  We're in the process of moving a database from an old SQL Server 2000 instance to SQL Server 2012. …

  joffwilliams

  4 replies

  12 years, 7 months ago

  By: joffwilliams

• SQL 2012 with Windows Server 2008 or Windows Server 2012?

  We're looking at migrating some of our SQL Servers to SQL 2012 (mainly for the BI improvements), bu…

  PhilipC

  7 replies

  12 years, 7 months ago

  By: PhilipC

• Looking for a faster count than count(*) for my sp.

  I have the following sp which is being slowed down by the following count statement: -(select COUNT…

  isuckatsql

  21 replies

  12 years, 7 months ago

  By: tomartbd