SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Testing for legitimate Time data type

  I've working on a project where I'm importing all kinds of filthy, dirty data into a new normalized…

  RedBirdOBX

  8 replies

  11 years, 11 months ago

  By: Jeff Moden

• Permissions and encryption

  Is there any way to restrict permissions so that a user can read from a database (and even decrypt …

  sqlsc-1053844

  7 replies

  11 years, 11 months ago

  By: Nadrek

• Database Monitoring Tools For MS SQL Server and Oracle Servers

  Hi, Can you please suggest me what are the TOP 5 best monitoring tools available for both MS SQL Da…

  Eshika

  3 replies

  11 years, 11 months ago

  By: david.bianco

• Survey guidelines about the execution time of a SQL Server agent job

  Hi, a my customer asked me to provide him some guidelines to conduct a survey about the variability…

  pmscorca

  3 replies

  11 years, 11 months ago

  By: pmscorca

• What is the correct way to restore a database when users are still connected?

  Hi, I have been a DBA for good few years now and have always had trouble explaining the best way to…

  Maddave

  12 replies

  11 years, 11 months ago

  By: Maddave

• Backup A Table - Structure and Data

  I have a 64 million record table that I need to create temporary backups of. I am cutrently using t…

  shindle 17293

  5 replies

  11 years, 11 months ago

  By: Keith Tate

• CLR function is giving me A big problem

  Hi Experts, I have created CLR functions to retrive data from sharepoint 2010 lists by sharepoint w…

  krishnaoptif

  1 replies

  11 years, 11 months ago

  By: Igor Micev

• "Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be "resent.

  Hi, I am getting "Failure sending mail: The specified string is not in the form required for an e-m…

  prakash_venus

  1 replies

  11 years, 11 months ago

  By: prakash_venus

• Using sql to search inside an AD group

  I am having issues with a LAN admin putting their username in a SQL AD group to gain access to SQL.…

  4x4krzy

  2 replies

  11 years, 11 months ago

  By: 4x4krzy

• NUMA - Node

  Hi, I need to verify memory size of each NUMA node in the system. Please share me the method how to…

  sudhakara

  4 replies

  11 years, 11 months ago

  By: sudhakara

• sql

  table1 ( whseid,col1, col2, col3) table2 (whseid, col5, sqlquery) table3 ( table1.col1,table1.col2…

  peacesells

  1 replies

  11 years, 11 months ago

  By: Luis Cazares

• Suggest a port other then default

  Hi at one of the client i have to suggest him a port other then default.Can anybody tell me how to …

  anoop.mig29

  8 replies

  11 years, 11 months ago

  By: Steve Jones - SSC Editor

• Logic for resolving issue

  Hi Expert, I need your help for resolving my one issue Table script, create table tmp_medal (medal_…

  kiran.rajenimbalkar

  1 replies

  11 years, 11 months ago

  By: Keith Tate

• Stored procedure performance update after index rebuild

  I have a stored procedure that runs every hour from 5 AM to 10 PM to check the pending orders that …

  sql_novice_2007

  8 replies

  11 years, 11 months ago

  By: Super Cat

• Express edition Performance tunning

  Hi Can anyone guide regarding how to do performance tuinning using SQl 2012 Express edition Regards

  Krishna1

  11 replies

  11 years, 11 months ago

  By: Bruceo