SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Filestream to store Office documents?

  I have been asked to look into using Filestream for centralising MS Office documents (mostly excel)…

  Eric Mamet

  9 replies

  11 years, 10 months ago

  By: Eric Mamet

• read committed for read only database

  i have a database which get refreshed every day from client's data . and we need to pull heavy d…

  Bhuvnesh

  2 replies

  11 years, 10 months ago

  By: marc 59598

• .NET website named users SQL Server 2012 licensing CALs or per processor?

  I am unclear about whether we have to purchase 1 CAL for every named user (named meaning a person w…

  pharmkittie

  3 replies

  11 years, 10 months ago

  By: sgmunson

• Where do I put my data

  Can anyone recommend some good articles on how and where to spread my data files across file groups…

  earbash

  6 replies

  11 years, 10 months ago

  By: earbash

• Copying a database to another server instance options

  We have SQL Server 2012 running on Windows 2008 Server. We need to copy five databases from our 'sa…

  HookSQLDBA7

  3 replies

  11 years, 10 months ago

  By: Perry Whittle

• Data validation options after data migration from Sybase to Sql Server

  Hi All, I am currently in the process of migrating data from Sybase to Sql server and would like to…

  Suresh Arumugam

  3 replies

  11 years, 10 months ago

  By: Suresh Arumugam

• can SSIS package replace stored procedure

  We require to convert a list of SPs in to SSIS packages. Most of the SPs do the below steps: mainly…

  raja.payani

  6 replies

  11 years, 10 months ago

  By: jfogel

• Best way to copy a database to another instance daily

  Looking for what others have done to keep a copy of a database, for read only, on another instance.…

  UconnDBA

  5 replies

  11 years, 10 months ago

  By: UconnDBA

• Calculate "Number of days to pay" logic

  I would like to ask for help to write a query that helps me calculate the number of days (approx) t…

  itortu

  10 replies

  11 years, 10 months ago

  By: Sean Lange

• Should Visual Studio and/or SSDT be install on production

  Hello, I have a BI_Stack configuration (DB, SSIS, SSAS, SSRS 2012) production environment, and I wo…

  Lord Slaagh

  4 replies

  11 years, 10 months ago

  By: Lord Slaagh

• login failure for SSMS

  TITLE: Connect to Server ------------------------------ I am not able to login to the SSMS, while I…

  raghumachineni

  6 replies

  11 years, 10 months ago

  By: Jack Corbett

• SSMS Login failure

  Hi experts, While practicing SQL DBA one of my friend by unknowingly he tried to restore the MODEL …

  prem.balu

  5 replies

  11 years, 10 months ago

  By: prem.balu

• Build test spoofed data

  Hi there, We have a massive list of 15-20 tables in the database which is loaded with data on a dai…

  Speedtest

  3 replies

  11 years, 10 months ago

  By: TheSQLGuru

• Cluster Errors - No Auto Fail over??

  I am somewhat of a beginner when it comes to clustering. I am learning on the job and looking into…

  GBeezy

  3 replies

  11 years, 10 months ago

  By: Perry Whittle

• Table not returning any result

  I am trying to run queries on a table (table has zero rows). Inspite of giving 0 rows returned the …

  gstarsaini

  3 replies

  11 years, 10 months ago

  By: Umer Akram