Learn more about SQL Server tools


Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Q&A List          Join

SQL Server Question and Answers

Ask a SQL Server Question

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

Importing SIS Data to Pre-Populated Tables
Hi!I am new to SQL and I am wondering if SQL will be a useful tool in automating Active Directory accounts from our Student Information System (SIS) exports.  The exports are Tab Delimited Text files and contain information that is in a different for

asked 10/31/2017 10:23:40 AM
by Randal Stowell
0 answers

Guidance in adding Azure to my Skillset
Hi,I have work experience in SQL Server BI ,Development , basic DBA skills. Would like to know where can I start with learning Azure and adding as skill set.  How much C# experience do I need to learn Azure ?.Every time when I open a book on Azure I

asked 9/28/2017 8:28:37 AM
by Rakesh
0 answers

Insert Excel Cell Value to SQL Query
Hi, I need to create a report with data coming FROM SQL server database with a WHERE condition that will be coming from the Excel file. Since we don't want excel to pull and store too many transactions, we only want the query to run based on the user's

asked 9/22/2017 12:05:05 AM
by RinRin
1 answers

Separating reporting database from Transaction DB
Hi All, I have a database which is frequetly updated with huge Data and the same databse is use for reporting. For the data loading to be fast we don't need indexes but the reporting need indexes to run faster. Am looking for the best option to separate

asked 9/19/2017 12:45:00 PM
by Kwabena
0 answers

Error code # 1642 when installing Microsoft SQL Server 2012 Service Pack 3 (CU) CVE-2017-8516 (4019090) for x64-based Systems on Windows server 2008R2 Enterprise edition
Hi, I am getting below errors in event viewer when I applied SQLServer2012-KB4025925-x64.exe(CU) patch on top of SQL server 2012 SP3 MS16-136(SQLServer2012-KB3194724-x64.exe)(QFE) components. But installation is successful and also updated version to la

asked 9/14/2017 11:46:03 AM
by Kiran
0 answers

foreign key have no reference to the child table
i have a parent table address contains addID (identity 1 , 1 ) as integer , area as varchar,streeat as varchar a child table client which contains addID as foreign key and clID PK identity(1,1) , name , fname ....  a form in VS which contains sever

asked 9/10/2017 2:09:58 PM
by mahdi
0 answers

cannot be opened due to inaccessible files or insufficient memory or disk space

asked 8/15/2017 10:46:39 AM
by Mike
0 answers

Script or ways to find out if SSRS encryption key backup completed
Hi Experts,          Is there a way I can find out if SSRS encryptlion key has been backuped up successfully and when the last backup completed. I am looking for metata/system table information or script to find out the results.

asked 8/11/2017 2:43:34 AM
by Dev
0 answers

Excel extensions and SQL server Packages
Hi Everyone,   I am new to sql server creating packeges and scheduling. Please help me with my questions, any information would be helpful. I have installed Sql server 2016 64 bit with data tools (17.1 for visual studio 2015) and sql server manage

asked 7/21/2017 7:26:41 PM
by Pranitha
0 answers

How to add cmd prompt messages in Sql unattended install
Hi  I am new to Sql server, and so far i'v installed a few Sqls using the standard gui & lately have done a few installs using the unattended approach. I wanted to get  progress messages in the cmd-prompt so I thought to put a few echo sta

asked 7/13/2017 11:43:05 PM
by john
0 answers

Convert String Datatypes
Convert the string:    "(id,created,employee(id,firstname,employeeType(id), lastname),location)"  to the following output  id created employee - id - firstname - employeeType -- id - lastname location  output in alpha

asked 7/11/2017 4:30:56 PM
by Rony
1 answers

MSDB database grows huge
we found that msdb database grows huge because sysxmitqueue table,  does anyone know how to shrink and solve this issue permanently  without  recurrence . the log shipping is configured on the serverthe service broker is enabled o

asked 6/6/2017 1:52:46 PM
by madhu
2 answers

SSRS Pie Chart
I have a pie chart with 2 slices having the same values. However, the pie chart only displays 1 slice. How can we have the pie chart displays all slices even if the same values? Thanks

asked 6/5/2017 2:52:15 PM
by Kim
0 answers

how can I open .mdf files?
How can I open .mdf files( SQL server files) and access the data. I  downloaded MSDE software but unable to install it says Strict username and psaaword required . were should i look for that. Are there any other solutions.

asked 5/24/2017 10:15:38 AM
by BjornPorgilsson
2 answers

Moving SQL from one datacenter to another datacenter
*** 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 text editor like NotePad before copyHi, I am working on to find some workaround for moving SQL Serv

asked 5/7/2017 7:26:56 AM
by Prasad
1 answers

sqlexception exception processing 'opensession' request failed to initialize the common language runtime
sqlexception exception processing 'opensession' request failed to initialize the common language runtime CLR V2.0.50727 due to memory pressure

asked 4/20/2017 3:24:39 AM
by Benson
0 answers

db mail cant be send without using script in sqlserver2012

asked 4/16/2017 11:58:43 AM
by sirisha
0 answers

SSRS Parameter Search on a long list id
I am creating a searchable SSRS report where staff can search the datasest on client ids. Staff should be able to insert client id (one at a time) into client id search parameter and then get all the info about the client in the report. The issue I have i

asked 4/14/2017 2:34:05 PM
by Helal Mobasher
0 answers

SQL Server SELECT statement error message
The column name is 'CandIDX' from a table called EHTNIG0040100. This is the Select statement from a VBA code in Access2007 frontend to retrieve data from SQL 2008  database: strSQL = "SELECT * FROM " & filenameB & _    &n

asked 3/31/2017 7:35:03 AM
by Laide
1 answers

Force ssl breaks user-defined functions
Im running sql server 2016 on an Azure VM with no vpn.  i want to force encryption over the network to all clients. I successfully changed the force encryption from no to yes and restarted sql server. (Using the autogenerated self-signed cert for no

asked 3/30/2017 3:01:51 AM
by Daniel
0 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-2017 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.