Learn more about SQL Server tools

solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips

   Got a SQL tip?
            We want to know!

SQL Server Question and Answers

Ask a SQL Server Question

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

issue with creating linked sever on Microsoft Windows 2008, with Microsoft Jet 4.0 OLE DB Provider
I have SQL server 2005 express edition running on Microsoft 2003 server. I need to create a link to MS Access files, which located on Microsoft 2008 server. The error message, OLE DB privider "Microsoft Jet database enjoine cannot open the file (.MDB). I

asked 9/19/2014 5:00:19 PM
by Marilyn Zhang
0 answers

SSRS Reports - Dynamically show one report in another report
I'd like to be able to add a report (Report2) to another report (Report1) when there is information in report2. Report1 and Report2 have been created and look similar,  but information in Report2 is not always available.  However, they sha

asked 9/17/2014 11:24:51 AM
by Chieko
2 answers

Expression for Joining and using a LookupSet for 2 datasets
I am a beginner and working in Report Builder 3.0. I have 2 Datasets where I am trying to compare the column in 1 to the column in another (1 to many, but also have blanks) where the final goal is to find which items in Dataset 1 do not have any matches i

asked 9/17/2014 9:25:56 AM
by Sheila
0 answers

Resource governor in mysql like MSSQL server
I am using MYsql 5.5 on my desktop PC, I want to know "how i can reserve resources like CPU, memory and IOPS " in mysql server. MSSQL server has Resource Governor tool through which we can do that.  I read about MYsql Governor but don't know whether

asked 9/15/2014 10:55:38 PM
by M.A Jan
0 answers

Limitation of buffer pool size
What happens if a data to be loaded from a disk in a buffer pool is more than the max limit of buffer pool. 

asked 9/15/2014 9:05:06 AM
by Snehil
0 answers

POS Transactions in SQL database
Hi,I am looking to view cashier transaction details in various Point of Sale Systems that use SQL Databases.Is there a standard format of tables that hold these details? Where and how would i be able to see where certain keystrokes are recorded in a Datab

asked 9/13/2014 12:09:14 AM
by LPS
0 answers

Database name with '-' in Transact-SQL Script (TSQL)
In Microsoft SQL Server Managment Studio (2008 R2), I am trying to set up a daily backup of a database using TYPE of Transact-SGL script (TSGE).  The database name has a '-' in the name.  The last line of the script will not pass the Parse becau

asked 9/10/2014 2:33:37 PM
by katty davis
1 answers

Connecting Sql server 2014 for developper in ADP project
  I can access sql server with management studio but when I try to connect the server to my adp project (MS 2010 and  Windows 7 ) I always get the same error message SQL State 080001 and SQL Server error 17 Server do not exists or access &nbs

asked 9/9/2014 2:28:59 PM
by Sylvie
1 answers

how to check replication latency using T-SQL
Is there any way to check all replication servers latency using T-SQL (using Central Management servers).OUTPUT should be cover below details.DBName     Publisher Server      Distributor Server          su

asked 9/9/2014 8:56:43 AM
by Gohil Rajesh
1 answers

sql server file placement
Hello my Fella DBA's I need your opinion. I just start a new job and most the Sql Server environments only have 3 San drives.Being that I only have 3 drives what's your opinion on how I should place the Sql Server mdf/tempdb mdf/ tempd ldf/user database

asked 9/8/2014 11:29:20 PM
by rogersdba
1 answers

Long running job
I need to create a job to find out long running jobs happening in the server for all the jobs.Is dat possible?

asked 9/7/2014 5:31:44 AM
by Prabhakar
1 answers

Dynamic Crosstab Query
Hi friends, I have a table like: DateOfSale   SalesPerson    SalesAmount Which may have any number of sales' staff (old/new workers) who have sold goods on different dates which may range at any length of time. Any suggestion

asked 9/6/2014 3:33:13 AM
by Faraz
2 answers

SQL Server failover clustering Active Active with Load balancing how?
Here I have two node  and  two instances working along with  same database restored on both instances of sql server  after done  of windows or sql failover clustering how can i bind both instances in one network name or ip address

asked 9/6/2014 2:23:41 AM
by kailash
1 answers

how to connect sql server
HI am anandharaj,I started newly learnig about SQL server,I have doubt on connecting client to SQL server ,how can i  connect my client systems(windows7 or other PC) to SQL server ,which  software i have to use to connect my client PC to connect

asked 9/5/2014 10:40:54 PM
by anandharaj
1 answers

Updating Hundreds of Millions of Records via Inner Join
Hi folks, I have a table with hundreds of millions of rows in which I want to update a single column in every row of that table. The value in which I'm updating the column with is stored in another table with tens of millions of records so I'm using an I

asked 9/5/2014 1:57:35 PM
by Michael Murray
2 answers

Flat File Unpivot
Hi everyone, I have a flat file (csv formatted, 9GB, 258 rows per record, roughly 10 million records). I would like to Unpivot most of the data in this flat file (252 columns) and store it in a SQL Server 2012 normalized table. When I use the Unpivot tas

asked 9/5/2014 1:53:37 PM
by Michael Murray
1 answers

Database Compression
How do i generate a report or query all the servers that has database compression enabled. We have around 200 SQL Servers and quite a few has database compression enabled. But we want to disable the compression. Is there anyway I can do it without going t

asked 9/4/2014 12:51:53 PM
by Anil Yadav
1 answers

SQL server hot stand by
We have requirement of SQL based application running on two physically different server machine which uses SQL server database work as active and stand by servers. All the time both the database should be synchronized, like data inserted in active SQL se

asked 9/4/2014 8:28:13 AM
by Abdul Rasheed
1 answers

Sql server HA_Logshipping Error((Microsoft SQL Server, Error: 14262))
Hi All, an error occured while configureing logshipping in SQL Server 2008R2 Ent.Edition. can one of you please suggest me how to fix this error ================================= TITLE: Microsoft SQL Server Management Studio----------------------------

asked 9/2/2014 8:28:13 PM
by Syed
1 answers

How can i display the report fromat in SQL Server 2008 R2 in Front-End(User-Interface)
HI, I have inserted(Imported) multiple excel sheets in SSIS 2008 R2 and getting the Report in the BIDS Sql Server 2008 R2 but i want to display the result in front end (i.e like search option / product details) but in sql server 2008 R2 i can not able to

asked 9/2/2014 6:37:55 AM
by Bhaskar Reddy
0 answers

Sponsor Information

Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | today's tip | first timer?
Some names and products listed are the registered trademarks of their respective owners.