Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

Questions

Ask a SQL Server Question

Search All Questions:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [Next >>]

How to speed up my server Dear Sir, we are running 7 different databases in on server [Server configuration Intel Xeon 2.53Ghz]. databases sizes are following   Name Db_Size A 181.94 MB B 70.50 MB D 60138.00 MB E 156.44 MB F 4369.38 MB G 156281.13 MB H 434.19 MB   My	asked 2/21/2012 9:55:04 AM by MMM Shukri 0 answers
SQL Statement Good day Sir, I have one table <StoTrans> Table Structure = RepDate (DateTime), PartNo Nvarchar(20), PartDesc Nvarchar(30), StkInHand (Float), NPurQ (Float), IssQty (Float) I want to... Select Partno, PartDesc, StkInHand from the table that h	asked 2/20/2012 4:04:21 AM by ZeS 0 answers
Load sharing on a different server Dear frinds: Consider a large site with many users. I want the project database on the server for 3 to speed up distribution. How do I make the connection be	asked 2/18/2012 4:19:38 AM by Vahid 2 answers
use of varchar(max) in sql server 2008r2 please give me complete information about use of varchar(max) in sql server. about its performance. is it efficient? its other characteristics. its mirits and demirits. thanks, amir	asked 2/17/2012 4:58:57 PM by amir younas 1 answers
roll back Dear sir,               i issue delete commond on a table without where condition and all my data has been deleted. is there any way to bring back my data.   thanks, amir	asked 2/15/2012 9:14:58 PM by amir younas 2 answers
Adding a second sql server 2008 instance Hi all, I would want to know how can i add a second sql server instance in SSMS 2008, is the same procedure as in sql 2000? I appreciate	asked 2/15/2012 9:25:35 AM by João Gabriel Mazuze 1 answers
Installing and Configuring MS DTC on W2k8 R2 Cluster Hi I have built  2 node failover cluster using Windows 2008 R2 Enterprise, all works fine - next step is to install MS-DTC before SQL 2008. So, have added the DTC elements of the application role to the 2 nodes, and then went to add the DTC resourc	asked 2/14/2012 5:15:28 AM by Simon 2 answers
Error 40001(1205) I am working on this Error  "Error 40001(1205) : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction." Any Idea how to solve this please/ Thanks	asked 2/13/2012 5:27:02 PM by Ankit shah 1 answers
write a trigger for stoping dml operations at particular time	asked 2/11/2012 5:39:29 AM by kareemulla 2 answers
SQL server 2008 Exp I'm new to sql server 2008 database. Would like to know step-by-step how to give READ or WRITE data permission to windows user (group)  to a particular database name.	asked 2/10/2012 9:57:11 AM by Hansa 3 answers
Excel Functions inTSQL Hi All,   I guess it is possible to use any of the Excel functions within TSQL stored procedures?   Please can someone show me how with an example calculating YIELD(settlement,maturity,rate,pr,redemption,frequency,basis) Thanks in advance	asked 2/9/2012 7:51:51 AM by Femi Adeniyi 1 answers
SSRS report throwing run time error from report manager Hello,When i am running few reports that have 3+ parameters having many values (>100) then sometime the report is throwing the runtime error as described below;Webpage error detailsUser Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Triden	asked 2/9/2012 1:44:50 AM by Romil Nagrani 2 answers
select of data from excel into sql server dear concerned, i am using the followng configuration  os=windows 2003 server sql server=2005 ms excel=2007 i select data from excel using the following configuration and query. EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; G	asked 2/8/2012 6:12:31 PM by amir younas 9 answers
date conversations *** 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 copying the code below to remove the SSMS formatting hi.. I have a	asked 2/8/2012 11:52:43 AM by deepak 1 answers
SSRS interview tips	asked 2/8/2012 6:08:19 AM by Archana 1 answers
Sum Function by Account Num Hi , i used  sum function in my report but i want  just this func. add same account num but function add all account num how can i do this? and sorry for my bad English	asked 2/7/2012 10:07:32 AM by MuMMY 1 answers
Dynamin SQL script to return backup statements for all the databases on my production server	asked 2/7/2012 6:43:53 AM by Pinkett 5 answers
how can we find the last record in a table without using orderby	asked 2/7/2012 4:23:44 AM by srikanth 2 answers
which career path is better; system admin or sql database admin?   in a big confusion.. In my company am being offered to choose system admin including Vmware,Windows and NetApp administration or Database admin including only MSSQL server as career options. I need to choose any one as my Primary Career! Am confus	asked 2/7/2012 2:57:39 AM by Bugra Ulusoy 2 answers
what are the best practice for mssql database parameter configuration settings	asked 2/4/2012 7:01:32 AM by Shola Aremu 1 answers

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [Next >>]
 

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen." Quickly and accurately deploy database changes with Red Gate's SQL Compare - the industry standard comparison and deployment tool. Do you need some help to solve SQL Server problems you are facing? Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Are you waiting on SQL Server? Learn about these DMV's.