SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Select case in sql server 2012

  Hi, I am using the below query,  select t.range as [Type], count(*) as [Value]from (  sel…

  poornima.s_pdi

  9 replies

  9 years ago

  By: poornima.s_pdi

• The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

  Hi Experts, While running the query on different months work fine but not running on 31-December-20…

  smer

  4 replies

  9 years ago

  By: smer

• Report Settings in SSRS - How can we make this setting [Do not timeout Report] be selected in All reports

  Please see attached I have over 600 reports and I am looking for a way to make this setting selecte…

  mw_sql_developer

  7 replies

  9 years ago

  By: Sue_H

• Help me with the query - Reporting Server related

  Select top 100 C.name, C.Path, S.* FROMCatalog C INNER JOIN Subscriptions Son ( C.ItemID = S.Repo…

  mw_sql_developer

  4 replies

  9 years ago

  By: mw_sql_developer

• DMV for index options (such as ONLINE)

  Hello, I have a script that returns lots of useful information about all the indexes in my tables. …

  brett.walker

  2 replies

  9 years ago

  By: brett.walker

• Conver varchar date to date only

  One column store date format like varchar below 20151025 How to convert to date only (removes the t…

  adonetok

  10 replies

  9 years ago

  By: MMartin1

• Cannot use a variable after initializing - multi-part identifier could not be bound

  I'm wondering why i cannot grab a column value and use it down the line in my sql statement/stored …

  Zososql

  4 replies

  9 years ago

  By: Zososql

• DBCC CHECKDB running more than 20 minutes on 500 MB database

  Hello experts, Does anyone know what would cause DBCC CHECKDB to take in excess of 20 minutes to ru…

  webrunner

  8 replies

  9 years ago

  By: webrunner

• Using a DR Script with Encrypted backups

  I hate to do a double post, however, my topic in the DR forum hasn't had any notice 🙁 so i thought …

  Thom A

  8 replies

  9 years ago

  By: Thom A

• Convert Datetime to UTC based on TIME Stamp

  Hi Expert, I have a table where i am logging my app navigation log and its in different time zone. …

  vijay.singh 46672

  9 replies

  9 years ago

  By: John Mitchell-245523

• Decommissioning SQl 2005 server

  Hi, We’ve migrated databases from SQL 2005 to SQL 2012 and we want to decommission the SQL 2005 Ser…

  SqlSavy

  5 replies

  9 years ago

  By: Steve Jones - SSC Editor

• Installing SQL Server 2012 Express failed on Windows 10 Home

  Hi I have had no luck installing sql server 2012 express on to a windows home machine. When I go th…

  daniel.woodnutt

  5 replies

  9 years ago

  By: daniel.woodnutt

• sql server local instance 11.0 and 9.0

  Hi All, Not sure, why am I having so many issues with LocalInstance. I finally opened the ssms.exe …

  anjaliagarwal5

  1 replies

  9 years ago

  By: sgmunson

• Access Violation Exception when starting SSMS 2012

  I recently installed SSMS 2012 on my local PC. Every time I start it, I get an error: "SQL Server …

  amy.holzinger

  14 replies

  9 years ago

  By: amy.holzinger

• Requirements to export data into an .xlsx file

  Hello, I've just been asked to prepare a query and generate it into an .xlsx file. There are numer…

  richlion2

  6 replies

  9 years ago

  By: frederico_fonseca