Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Query error

  Hi i am getting the below error when i run this query. Msg 241, Level 16, State 1, Line 2 Conversio…

  smharabbani40

  5 replies

  11 years, 2 months ago

  By: ChrisM@Work

• sql server 2012

  hi folks, this is Imran, and kind of new bee to sql server 2012, I wanted to know what are the pre-…

  iksuleman

  4 replies

  11 years, 2 months ago

  By: Orlando Colamatteo

• Clustered indexes

  Clustered indexes also have some disadvantages compared to heaps. When you insert a new row into a …

  mtz676

  5 replies

  11 years, 2 months ago

  By: Gail Shaw

• Execution Plan Drilldown Issue

  I am trying to list the execution plan in xml (SET SHOWPLAN ON) of a given sp in a query that retur…

  zachary.curtin

  3 replies

  11 years, 2 months ago

  By: zachary.curtin

• Help with sql statement

  I am new to vb and sql . please bear with me I have a database name database 1. I have column name …

  rony09830

  4 replies

  11 years, 2 months ago

  By: SQL Severe DBA

• Error while running dtsx package on 2008 R2

  I am getting the error below while executing the package, Error: System. Runtime InteropServices.CO…

  bubby

  7 replies

  11 years, 3 months ago

  By: Jack Corbett

• SQL Agent jobs status while running

  Dear all, I have around 80 SQL agent jobs. and these jobs will run in the duration of 3 hours. i ca…

  sushilkumar217

  10 replies

  11 years, 3 months ago

  By: Satish S

• Trying to convert varchar to datetime

  I am trying to convert 20114 which is stored as varchar to datetime but I am getting the following …

  savycara

  17 replies

  11 years, 3 months ago

  By: karanraju2k13

• How to defrag tables by filegroup

  I want to be able to run the defrag indexes on tables by filegroup one at a time. Example: Defrag i…

  LearnSQL!!!

  5 replies

  11 years, 4 months ago

  By: LearnSQL!!!