Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

SQL Server Always On
Hi , i am planning to build HA SQL solution using Availabily groups , i have cluster on data center and i want to create SQL instance on DR site, and create availability group,  but my application doesnt support AG(so when i switch DR site i need t

asked 4/28/2016 5:48:07 PM
by khaled
0 answers

Is it right to use default schema (dbo) in all objects in sql server
Hi,  I want to know that is it right practice to use default (dbo) schema in all object in sql server ??

asked 4/27/2016 3:39:35 AM
by Saurabh
0 answers

Hi, i have a performance problem with a simply query that work very slow!!! this is my scenario Mgmov TABLE  -- with the following definition CDMG CHAR(5), DATA SMALLDATETIME, ANNO AS (YEAR(DATA)), CDAR CHAR(20), Colore CHAR(6) , Ta

asked 4/25/2016 3:37:30 PM
by Gianni
1 answers

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
Hi all, after patching sql server 2008 sp4 on a passive node of vcs cluster and failover the services/resources to active to passive node, we failed to connect database engine locally through ssms, but from other box we connect the same DB engine easilly

asked 4/21/2016 3:41:00 AM
by Subhamay Chatterjee
0 answers

Use powershell to insert a list of directory files with modification date into a SQL Server table
I know I can search if a particular file exists in a directory, but how to I generate a list of all the files in a directory> If a flatt file is generated, I can always use a SSDT package to import, but is there a way to save the file name and the modi

asked 4/17/2016 3:02:39 PM
by Sandy Shin
0 answers

Windows 2012 Failover Cluster + SQL 2014 tempdb does not shrink
Hello, I've been reading a lot about this topic but nobody seems to have an answer. So I'm trying this forum. We have a VMWare environment where we have a Windows 2012 failover cluster, build with shared vmdk "disks". This all works fine for almost a ye

asked 4/14/2016 8:36:58 AM
by Tom Huis
0 answers

Sql database flagged as suspect
*** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a texWe run SQL on a Win2K server. The database for an OOB product began to be flagged as 'suspect' a

asked 4/10/2016 9:13:17 AM
by perkins
0 answers

Performance Tuning an off the shelf system
I have read some articles about perfomance tuning and monitoring. They all asume that I have written the application. What if I am using an off the shelf system? Is it feasible or advisable for me to do any performance tuning of SQL? As part of my main

asked 4/7/2016 5:56:23 PM
by Paul Kelly
1 answers

How to create a fixed database db_owner role with dbo behaviour
I suppy specialist data management software to the geothermal industry that uses SQL Server.  This data is "owned" by the program users (geothermal scientists and engineers) - in other words, they collect, collate and enter the data for their own pro

asked 3/18/2016 8:49:23 PM
by Errol Anderson
0 answers

Show all tables where two columns exist - SQL 2008
I want to a search for all tables that includes both of  'Documentversionid' and 'ClientMedicationID' columns.    Thank You,   Helal

asked 2/29/2016 8:02:54 PM
by Helal
1 answers

Slow ETLs on weekends
Hi, I am having slow runs of ETLs that otherwise run for 15 minutes, taking close to two hours on weekends. I have ensured nothing else such as db maintenance is running during the times of delayed runs. The job spids are of the type CXpacket,  Lat

asked 2/22/2016 6:05:31 AM
by Gummy
0 answers

Slow ETLs on weekends
Hi,   I am having slow runs of ETLs that otherwise run for 15 minutes, taking close to two hours on weekends.I have ensured nothing else such as db maintenance is running during the times of delayed runs. The job spids are of the type CXpacket, &nb

asked 2/22/2016 5:46:37 AM
by Gummy
0 answers

Getting data from multiple tables
I have 3 tables. The first table 'Status_Mapping' has following columns Status_orignal Status_Site accepted Call Verified duplicate Duplicate Leads dnq DNQ Now the other table 'Lead_transaction' has the columns Lead_instance_id Rate Status 110.01 acce

asked 2/12/2016 3:48:39 PM
by Shibon
0 answers

SSIS failing to read from registry
Hi, I have bunch of SSIS scheduled through Tidal. No issues in non production environments [ Microsoft SQL Server 2012 Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)].But only couple of SSIS packages (same one) fail

asked 2/4/2016 9:41:08 AM
by Mohamed
0 answers

Sql Injection re Bulk Insert
Hello Guys: Does Bulk Insert properly escape input? Or do I have to worry about SQL Injection when performing a Bulk Insert? I am using a flat file for input, and a format file. In my format file I specify the columns as SQLCHAR. Does that type indicat

asked 2/2/2016 3:31:16 PM
by John Turpin
0 answers

SQL SERVER Default Trace file
Hi all, I have some questions regarding SQL Server Trace files.. Q1. How SQL Server Manged Default Trace files? is it archived autometically ? If yes then retention period ? Q2. Can we  extented the retention period of Default Trace manually ? &n

asked 2/2/2016 8:14:25 AM
by Subhamay Chatterjee
0 answers

mysql database confusion to store user phone contact list
  My requirement:when any user will create a profile to my application from their mobile phone, their phone contact list will upload to server mysql database.Now:User table=============uid,userId, username, passwordContact table===================

asked 2/1/2016 5:12:29 AM
by arijit
0 answers

Request for solution to implement SQL Server Replication between Local Premises DB Server and Cloud DB Server which are not on a domain
Hello,   Hope you are doing fine.   I am writing this email to ask you an implementation doubt regarding replicating data between SQL Server 2014 database servers (Replicating data from Local Premises SQL Server to Cloud DB Server, which are

asked 1/29/2016 7:36:50 AM
by Nikhil Satam
0 answers

Easy SQL Query, Need Help.
Hello I recently made a CDN so I wanted to move all my current urls of images on namestyles to the new urls, they all end in the same image number and extension but I wanted to replace example.com/z/imagenumber.imageext to cnd.example.com/i/imagenumber.im

asked 1/28/2016 11:20:25 PM
by Kevin
0 answers

Can I create/modify objects on SQL Server 2014/2012 using SQL Server 2008 Management Studio on client machines?
  Our application has SQL Server 2014 as database server. But our client machines or developer machines still have SQL Server 2008. We are able to connect to SQL Server 2014 DB but we are facing issues while creating or modifying any tables or SP'

asked 1/12/2016 4:48:36 AM
by Nikhil Satam
1 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?




User Groups

Author of the Year

More Info








Copyright (c) 2006-2016 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.