SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• login/user cannot execute or see stored procedures

  We are using a third party tool that does not store passwords in an encrypted format therefore we c…

  Tobar

  5 replies

  11 years, 11 months ago

  By: Tobar

• Msg 6517, Level 16, State 1, Line 1 error on database integrity

  Hello all, i m getting this on the beginning of DBCC CheckDB Failed to create AppDomain "master.s…

  zouzou

  1 replies

  11 years, 11 months ago

  By: Steve Jones - SSC Editor

• SQL 2012 AlwaysOn Group Configuraiton Issue.

  Dear Gurus, Hope all is well. i am confronting one error while configuring the SQL 2012 AlwaysOn G…

  sheeraz.khan

  1 replies

  11 years, 11 months ago

  By: Perry Whittle

• reporting services would not send subsciption emais

  Hi, I am running RS 2012 installation and everything worked until few days ago. Now the subscripti…

  Roust_m

  2 replies

  11 years, 12 months ago

  By: Roust_m

• CI and NC index on same column is it sugestable ?

  Hi, I have a question regarding indexes. If i have cluster and NC index on same column,does it degr…

  sql.lanka

  3 replies

  11 years, 12 months ago

  By: sql.lanka

• Missing Index suggested by missing index script

  These index came from the query that reported missing indexes, but I’m just trying to get a better …

  Zohaib Anwar

  6 replies

  11 years, 12 months ago

  By: ScottPletcher

• Encrypting data from Oracle to MS SQL over WAN

  I have been tasked to find a solution for Encrypting data being transferred from an Oracle database…

  jlbradford

  6 replies

  11 years, 12 months ago

  By: Eirikur Eiriksson

• T- SQL Query

  Hi I have a Table 'A' where column X is of type XML. Following is Column X value <qsds:Details…

  greeshatu

  1 replies

  11 years, 12 months ago

  By: gbritton1

• Parse XML Data to Table format

  Hi friends, declare @xml table (xmldata xml) insert @xml select N'<parseObject name="Motel">…

  sivaj2k

  2 replies

  11 years, 12 months ago

  By: sivaj2k

• SSIS tasks installation

  I'm seeking help from a real SSIS expert, which I'm not to any extent. I recently developed an open…

  spaghettidba

  8 replies

  11 years, 12 months ago

  By: spaghettidba

• Backup "fails"

  A few months ago, I added a simple, one-line job to backup one of my SQL Server 2012 databases -- a…

  Jim

  5 replies

  11 years, 12 months ago

  By: Jim

• Is there a fast way for SQL to do a Group By Count on items within a group?

  select top 15 count(*) as cnt, state from table group by state order by cnt desc select top 15 coun…

  isuckatsql

  13 replies

  11 years, 12 months ago

  By: Eirikur Eiriksson

• Left outer Join

  Good day I have 3 tables , Customer , Sales Cost Charge and Sales Price the Customer table will be…

  jason.kleinhans

  2 replies

  11 years, 12 months ago

  By: jason.kleinhans

• avg_write_stall_ms of tempdb

  Hi everyone, I'm seeing some really high average write stalls. As I have read, anything greater tha…

  PHXHoward

  1 replies

  11 years, 12 months ago

  By: TheSQLGuru

• SSRS: how to put 10 rows on first page and rest (1000+) rows on the second page

  Hi, Is there any way to control this scenario, I know trick to put 10 on each row ,but I need to sp…

  mario17

  3 replies

  11 years, 12 months ago

  By: mario17