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 >>

What is the maximum data volume limit for SSIS in 48 hours time frame
What is the maximum data volume limit for SSIS in 48 hours time frame Using SSIS Dataflow with Cache manager(No Lookup), Buffer size and Defualt Buffer is set according to requirement.  

asked 9/2/2016 5:44:58 AM
by Swapnil Chaturvedi
0 answers

Sql database from .mdf file
We are using sql server 2005 on Win7.  The disk containing our sql server ldf files crashed so we lost them.  We have all the mdf files though. Can we recover these databases.? We have tried creating a new database, stopping sql server, repla

asked 8/23/2016 10:39:31 AM
by tobypaul509
4 answers

ssis
i have a table like bellow id       code                FName                       LName    &nbs

asked 8/18/2016 1:36:25 AM
by ali
0 answers

Delete the header of XML for deadlock email attachment
Hi I have a standard WMI deadlock alert and when alert is fired I am inserting the XML into a table but then when I open it the root of the XML is with <TextData> and I need to deleate it manually as well at the bottom of the XML and then I can

asked 8/16/2016 11:45:47 AM
by Konstantin
1 answers

Detach database loosing file level permissions
Hi There   My project is on sql server migrations runs on powershell commands. When database is detached file level permissions like owner are set to the person who has detached the database. if other person in a shift comes and want to delete th

asked 8/4/2016 12:41:34 PM
by Phani
0 answers

Need Help On My Procedure When I Post, Total Paid Amount Does Not Balance With Distributed Amounts
  I receive Total Month Contributions as a sample shown and Try To Distribute on Members Ledger,Members Profile and Keep Trail Of Excess Payment when Member Completes Loan Repayment. Excess Payments are To Be escalated to Members Deposits and Loan

asked 8/3/2016 1:06:37 AM
by chris
0 answers

Copy All Tables from IBM DB2 schema to SQL Server
I am trying to come up with the best and most efficient way to copy more than 700+ tables from an IBM DB2 iSeries schema to SQL Server. I have tried the followings: 1. I have exported all the 700+ tables into csv files but I am not able to upload them al

asked 7/25/2016 4:34:38 PM
by Helal
1 answers

Apply SQL Server 2008 R2 SP3 on passive node and getting an error message "The SQL Server failover cluster instance 'SQL_Report' was not correctly detected"
Apply SQL Server 2008 R2 SP3 on passive node and getting an error message "The SQL Server failover cluster instance 'SQL_Report' was not correctly detected"   Trying to apply the SQL Server 2008 R2 SP3 on passive node but getting an error message t

asked 7/19/2016 6:26:02 PM
by Iqbal B
0 answers

SQL database restore faile
when i restore the sql database i am getting error TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'MAIN'. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=M

asked 7/18/2016 10:39:39 PM
by Sugirthan Sugirthan
1 answers

MySQL database issue
I need help to restore a mysql database. I'm using cpanel and phpmyadmin.I see not restore function in phpmyadmin.

asked 7/12/2016 1:49:41 PM
by FrankKelly
3 answers

Store result of dynamic pivot into temp table
I have the following cte dynamic qury and need to inser teh results into a temp table. Here is the script: DECLARE @serviceid int = 66;  DECLARE @SQL nvarchar(max);  WITH  E(n) AS(  SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0)

asked 6/27/2016 11:31:56 PM
by Helal
1 answers

DB backup initiated by NT AUTHORITY\SYSTEM
We are taking Nativae backups daily and some of backups are intitaited by NT AUTHORITY\SYSTEM. There is job was configured. i am finding the below message from error log. I/O is frozen on database msdb. No user action is required. However, if I/O is not

asked 6/24/2016 4:14:49 PM
by sree
1 answers

Converting Rows to Columns Dynamicly
I need to convert my data set from multiple rows to columns and sum by multiple fields. Below is sample data and desired outcome. The data have 7 rows and I need to pivot this to one row for each serviced and sum the last three columns (ChargeAmount,Adjus

asked 6/23/2016 9:31:35 PM
by Helal
0 answers

SSRS Batch Processing
I have an SSRS report that when ran will generate thousands of records.  Each record has it's own unique ID.  What I want to see happen is to kick off the report and each record (each unique ID) will be exported to a PDF to a predetermined folde

asked 6/20/2016 1:58:08 PM
by Conor Chaput
0 answers

SQL Server 2012 - Licence Quantity Details
Hi,   We have SQL Server 2012 software of Enterprise and Standard Edition.   1. Microsoft SQLSvrEnterpriseCore Sngl Licence/SoftwareAssurancePack  OLP 2Licences LevelC CoreLic -  Quantity 32    2. Microsoft SQLSvrStanda

asked 6/20/2016 8:51:07 AM
by NIKHIL DESAI
0 answers

a severe error occurred on the current command. the results if any should be discarded
Hi, We usually get the below error in my organisation dont know the exact reason please help "a severe error occurred on the current command. the results if any should be discarded"

asked 6/8/2016 8:39:19 AM
by Satish Vishwakarma
0 answers

DBCC CHECKDB has failed giving error as "Extent (1:31218136) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it", our client has refused to run DBCC REPAIR_REBUILD or DBCC REPAIR_ALLOW_DATA_LOSS. Is there a solution where I can find the table linked to the extent number and drop and rebuild the table only
Below is the complete error as written to the error log of the sql server.   DBCC RESULTS -------------------- <DbccResults>                    &

asked 6/2/2016 5:02:38 PM
by Manish Yadav
1 answers

Recovery Backup
  Hai       This is Mahesh,I have one doubt of SQL SERVER DBA I am settings in backup every sunday 12 am fullback up.     for every 6 hours differential backup.every 15 min t log back up.  If my server cra

asked 5/26/2016 11:55:36 PM
by Mahesh
1 answers

Using Cross Apply to retrieve one random row
-- CREATE TABLES AND LOAD THEM WITH RANDOM DATA SO THAT WE HAVE SOMETHING TO WORK WITH  CREATE TABLE #JJJ(inv int); CREATE TABLE  #PPP (Rand1 INT, Rand2 INT)  ; GO INSERT INTO #JJJ SELECT TOP (60)inv = ABS(CHECKSUM(NEWID())) % 123 FRO

asked 5/6/2016 11:03:44 AM
by Jerry Day
2 answers

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


 
Sponsor Information






 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

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