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

SQL Server Question and Answers

Ask a SQL Server Question

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

How to diagnose network and io bottle necks when extracting data from a remote sql server and is there any way to to know the raid configuration on an internal server or a remote server

asked 4/23/2014 10:23:01 AM
by praveen
0 answers

Data transfer from Production SQLSERVER database to thrid server when logshipping is running
Hi All, I m new in SQLSERVER. Our production server database  is configured with LogShipping which running successfully(Standby Mode). Now the scenario is that i have to configure logshipping again with production DB (Same Databse) with thrid server

asked 4/22/2014 8:06:09 AM
by Subhamay
3 answers

Missing index evaluation
I am working on analysing missing index suggestions provided by the sql server DMVs. As we know we cannot blindly add the indices provided by the sql server DMV. As a first step to evaluate the missing indices, I have created statistics with the same col

asked 4/21/2014 7:49:59 AM
by rudra
1 answers

Why there is need to execute a variable using "EXEC @var"

asked 4/19/2014 11:40:03 AM
by Amitesh
1 answers

Convert FLOAT to VARCHAR problem
When i converting FLOAT value to VARCHAR then some scale values truncated. and i can't fix  the scale length. DECLARE @Float FLOAT = 237.45785689675 DECLARE @Str VARCHAR(50) SET @Str = CONVERT(VARCHAR(50),@Float,129) SELECT @Str &n

asked 4/18/2014 7:40:41 AM
2 answers

failed with the following error: Extent (7:1145864) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
How to resolve the below issue? I have done RebuildIndex but the problem not solved.I think page restore will resolve the below issue but,I could not suppose to do.Can You tell me the steps to resolve the below Issue? Problem: Executing the query "DBCC

asked 4/17/2014 2:11:38 AM
by Rajasekhar Reddy
1 answers

Create Dynamics View
I have view somthing like Create view All_employee AS      SELECT Emp_Name, Emp_code FROM dbo.Employee      UNION ALL      SELECT Emp_Name, Emp_code FROM Emp_201402.Employee But we have a different "Schem

asked 4/16/2014 6:03:04 AM
by Hitesh Sharma
1 answers

Restoring database using powershell
Hello I have gotten part of this powershell script from the web, and first part configured by me. #Define Variables and configure variables#----------------------------------------#First Set the target database on server1$targetdb ="DevTest2010_Content8

asked 4/15/2014 10:15:52 AM
by Paresh Motiwala
0 answers

Insert from one database to other database
          Create PROCEDURE [dbo].[AccountInvoice1]        @fnModule varchar(100) output  Dear Team   I am facing problem to call from one database to other, we have two different database, fr

asked 4/15/2014 3:47:01 AM
by Sheethal Kumar
2 answers

Connect remote MSSQL 2012
Hi. I have problem in connection with another server. I am using VM ware. One VM Ware is holding Database (MSSQL 2012 Standard Edition). In another VM Wear, I am using IIS 8. I am hosting aspx pages in IIS8 and try to connect MSSQL Server through IP. Bu

asked 4/15/2014 1:57:05 AM
by maideen
0 answers

Table Size Estimation
Hi Guys,   I have 2 files:   1) 242,000,000 records with a record size of 552   2) 222,432,278 records with a record size of 1,295     Please let me know how much space will be needed to load each table.   also tel

asked 4/14/2014 4:23:23 PM
by Satish Vishwakarma
1 answers

Sharepoint & MS Sql report server
Hi , 1_  we have two server (2 computers)  , one for sharepoint 2010 and the second for MS SQL server , >> when we try to integrate Sharepoint with Report server Through Sharepoint Central Administration --> Report Sevices Integratio

asked 4/14/2014 4:57:14 AM
by H. Turki
0 answers

Sharepoint & Ms SQL report server integration
Hi , 1_  we have two server (2 computers)  , one for sharepoint 2010 and the second for MS SQL server , >> when we try to integrate Sharepoint with Report server Through Sharepoint Central Administration --> Report Sevices Integration

asked 4/14/2014 4:24:52 AM
by H. Turki
0 answers

transfer data from MSAccess to SQL server management Studio
Hello,I have a couple of tables (with +250K records) in MS Access that are updated daily. I would like to transfer these tables to SQL Server management Studio every day automatically. I am not in programming so any kind of programming help would be treme

asked 4/11/2014 2:01:29 PM
by sanjay
0 answers

SQL Server 2005
Saludos...   Estoy intentando activar las siguientes opciones en el SQL Server 2005:   * Audit Level * C2 Audit Mode   y no he podido da con esto..   Por favor ayudarme.

asked 4/11/2014 12:00:14 PM
by Eddy Henriquez
0 answers

will a trigger fail if every 15/30 sec a row gets added to table
I would like to know if trigger will fail if every 15/30 seconds a row gets inserted into the table. This GPS data.    

asked 4/11/2014 5:22:48 AM
by Satya Sai P
0 answers

sql performance
who is the best bigint identity or guid for clustered primary key?

asked 4/9/2014 2:02:03 PM
by Jean-Pierre Lebrasseur
0 answers

DTD is prohibited in this XML document
Hi, I am working on a SSRS 2012 report for XML data source using an HTTP link to an XML document. I am having a DTD issue when attempt to run the query. Please help. String: http://localhost/results.xml   Action {}/Step {Obj,Details,Time,NodeArgs}

asked 4/9/2014 12:28:16 PM
by Angel Barrientos
0 answers

Configuring MSSQL to support kerberos authentication
I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment . The windows station is in a workgroup and I would like to avoid having to setup a domain controller and active directo

asked 4/9/2014 12:18:06 PM
by D
1 answers

How to load data from different server through tsql or SSIS
I have to load data from two different server. What I have already: I have two stored procs that creates table (if its already not there) and then load data. These stored procs are used to load multiple tables from point A to point B. Problem: I have a li

asked 4/7/2014 4:46:39 PM
by Stephen
1 answers

Sponsor Information

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