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 memory issue
Dear all, We are running a databse of a production related data entry & reporting application in SQL server 2008 R2 in a Dell R610 server with 16 GB RAM. But we are facing ***ical memory issue with SQL server and it use 97% of physical memory and par

asked 3/4/2015 6:55:18 AM
by prabhath
1 answers

In sql server manager one instance stopped issue occured service did not respond in timely fashion and user having administartor privillages

asked 3/3/2015 1:55:49 AM
by Priyanka Belhekar
0 answers

SSIS variable using
Hi, I've a problem to solve this request. Cause I get an error like : "incorrect syntax near ','". Please, is there anybody to help me solve this error? Here is my request usnig in the Execute SQL Task Editor: "INSERT INTO LOG_CHARGEMENT_ODS_LCO SE

asked 3/2/2015 6:28:50 PM
0 answers

When you load the data into a new partition table, can it to done online without any downtime? because I have few tables that are around 250 gigs and more.

asked 3/1/2015 10:55:28 PM
by iqbalbutt
0 answers

Flip Data in SQL
I have received data in the following format:ID, Name, [201401],[201402],[201403],[201404],[201405],[201406]) '1', 'Joe', '0' , '0', '0', '0', '1', '0' '2' , 'Sam', '0' , '1', '0', '0', '0', '0' '3', 'Jill', '1' , '0', '0', '0', '0', '0' I want to flip da

asked 3/1/2015 9:11:34 PM
by Helal
1 answers

Covert rows to columns
I have received data in the following format: ID, Name, [201401],[201402],[201403],[201404],[201405],[201406])   '1',  'Joe',   '0' , '0', '0', '0', '1', '0'           &nbs

asked 3/1/2015 8:58:58 PM
by Helal
0 answers

Using temp table is SP
I am using a Temp table in a SP, its looks to me that when a insert data into the temp table, all existing data in that temp table beeing lost, So what is the way to add data to temp table, and adding again data to same temp table, and it should be kept t

asked 3/1/2015 5:11:15 PM
by cnngold
1 answers

Index rebuild and table statistics
Hi, i have confusion between gather table statistics and index rebuild on same table..Question is that whether one index rebuild gathers all required statistics  for the same table or gather statictics is equvalent to index rebuild.. Eg.. update s

asked 3/1/2015 12:35:13 AM
by satadru
0 answers

Audit functionality monitoring
My Audit and Compliance section is requiring us to develop a daily monitoring checklist to determine if audit functionality fails if automated alerts cannot be generated when the audit functionality fails. I'm not finding anything that specifically addre

asked 2/27/2015 12:51:30 PM
by Gary Wright
0 answers

Problem moving clustered indexes to a different File Group
I started looking at this as a follow-up to the article by Feodor Georgiev - Curing Data-Obesity in OLTP Databases - just a day or two back. So I ran a few experiments on AdventureWorks2012, adding a new File and File Group and re-creating all clustered i

asked 2/27/2015 10:13:06 AM
by Gordon
0 answers

Clarification on Always on
Hi All, I am a DBA. In our organization we are using SQL Server 2012. So far, the High Availability concepts that I have worked are Mirroring & Log shipping. Now, we are planning to implement "Always on" in our organisation, which is new to all of

asked 2/27/2015 5:39:48 AM
by K P Senthil Kumar
0 answers

Procedure or function has too many arguements specified
A while back this community gave me very helpful info on backing up sql databases and I'm here again looking for more help. Thanks ahead of time for any suggestions you might give here and I am not a SQL pro, just a lowly IT Associate, so the answer migh

asked 2/26/2015 1:08:12 PM
by Stephen
1 answers

Server Side trace causing query and ultimately connection timeouts, even several minutes after the trace is stopped?
I'm pretty flustered and don't know how to proceed.   To make a long story short, I'm trying (carefully) to get some replay traces from a pretty busy production 2005 SP4 instance.  I actually started using the default RML Util replay trace in s

asked 2/24/2015 8:10:08 PM
by dwaine wright
0 answers

how to identify the servers? like which one is production, test and development?
    I have 100 sql server instances how to identify the servers? like which one is production, test and development? in the real time environment.

asked 2/24/2015 11:51:38 AM
by sudha
2 answers

TITLE: Microsoft SQL Server Management Studio ------------------------------ Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (SQLEditors)
In Object Explorer, whenever I right click on any user-created-table inside a database and issue command like "Design" or "Edit Top 200 Rows" or when I am going to create "new database diagram" for my recently created database, I get an error stating, TI

asked 2/23/2015 10:43:00 AM
by prasiddha
1 answers

MSBI Sample Requirment
Recently, i got a simple requement with following detail. 1. I am have two excel files(Each Excel file is having  three Sheets) i.e  Excel 1---> Sheets --> 1.CompanySheet( CID,CNAME)               &nbs

asked 2/23/2015 1:37:48 AM
by Siva
0 answers

restore error in sql server database
When I want to restore sql database from I see the error: "The system cannot find the file specified.)". Any actions I should make? Please, some solutions to resolve!

asked 2/22/2015 11:08:33 AM
by keeganwalborn
2 answers

SQL server using 95% RAM
  Hi team, I have sql server using 93-95% RAM.current max memory setting for SQL Server is 43GB and Total RAM is 48GB. In task manager its showing 46.5GB for sqlsrv.exe 1 Dont know which process/query taking more memory? 2 Do we need to add mo

asked 2/20/2015 1:27:19 AM
1 answers

Unknown process taking system databases backup
I am seeing some unknown system process is taking system databases backup. There is no error and the output message as below. "Database backed up. Database: msdb, creation date(time): 2010/04/02(17:35:08), pages dumped: 1854, first LSN: 209:362:217, last

asked 2/19/2015 3:28:08 PM
by Siva
0 answers

Performance on partition table
How to assure partition table is better performance than non-partition table

asked 2/19/2015 7:36:47 AM
by Debdulal Mahapatra
3 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?


Free T-shirt



User Groups

Author of the Year

More Info








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