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

improve the sql performence how to improve the sql server performence and database performence	asked 5/20/2012 7:34:54 AM by anand 0 answers
How to calculate differential backup size HI,   could you please tell How to calculate differential backup size? and how to view total changed extets after full backup as well.. Thanks in advance Adveeta	asked 5/19/2012 3:01:38 PM by adveet 0 answers
Incremental Load I haev 3 table. Source table, dim table and load table.. I have a source table .. In the source table there is Createddate columns. In the Dim table I have 2 more column ( LoadID, StageId - stageID as identity column. ) Like if the data is being loaded t	asked 5/16/2012 2:02:50 PM by Ronak 2 answers
Is there a way to add a new network protocol (HTTP) as the default options in (Sql Server) are VIA, TCP, SHARED MEMORY and NAMED PIPES.   Is there any way to change the network protocol (HTTP) on SQl Server for communication ? defaultly it uses TCP, SHARED MEMORY and NAMED PIPES. please suggest any solution for a client scenario ?	asked 5/16/2012 4:05:26 AM by Krishnaprasanth.N 0 answers
sql server 2012 installation problem I'm installing sql server 2012 on windows 7 home premium 64 bit. I've enabled .net framework 3.5 and rebooted but it keeps asking for .net 3.5Why???	asked 5/15/2012 10:56:04 AM by Parthasarathy Mandayam 1 answers
Deadlock Hi, If I find deadlock using sp_who2, what are the steps to rollback that transaction and is there any other steps need to be taken.   Thanks in advance.   Monil	asked 5/15/2012 1:19:36 AM by Monil 3 answers
how to track the last 10 modifications in a database Hi guys,   if we want to know the last modifications done in database,what should we do.actually all that information will store in database history.but if we want to log those modifications in a particular file,what should i do.please help me	asked 5/12/2012 11:50:34 PM by Anitha kola 3 answers
XP_CMDSHELL in connection with T-SQL variables Hello NG.I am looking for a solution for the following problem: DECLARE @outQuery as sysname, @var as sysname SET @outQuery = 'D:\xxx\xxx.sql'SET @var= 'del ' SET @var= @var   +  @outQueryEXEC xp_cmdshell  @var That works 100 % EXEC	asked 5/11/2012 5:35:50 AM by Peter-Sesam 0 answers
how many way to get the result set using while loop or if condition ? I need a date table that has all the dates from 2000 till today. the table should look like at below.. how can i get that using while loop or if conditon ? thank you, DateSk Date Day 20000101 1/1/2000  1 20000102 1/2/2000	asked 5/9/2012 5:21:32 PM by Ronak 1 answers
all date from year 2000 till now   I need a date table that has all the dates from 2000 till today. the Table should look like at below.. how can i get that ? DateSk Date Day 20000101 1/1/2000 1 20000102 1/2/2000 2 20000103 1/3/2000 3 200	asked 5/9/2012 11:44:46 AM by Ronak 5 answers
tracking the sql history in a particular file hai, Inorder to track all the database operations -like sql history, in a particular file(means in whatever the path we have given) what should i do.please help me by giving answer to this.	asked 5/9/2012 7:38:24 AM by anitha kola 0 answers
Query - Crosstab Hi,   I have a table named as Employee_Session Table where we save employe id and datetime when they login. I need a report of employee id and montly report how many times they logged in. NOTE: I need to write query without using any temporary ta	asked 5/7/2012 10:20:25 AM by Monil 2 answers
SQL 2005 Express Edition I am using SQL 2005 Express Edition as one of the SQL Database. I am planning to  develop  a portal which will be  accessed thru  Web from different location . my question is   1. Express Edition being free ware , will	asked 5/7/2012 4:27:55 AM by Anne 0 answers
SQL developer or Dot net developer     HI sir,...                                      &	asked 5/7/2012 3:13:19 AM by Arul 0 answers
xml bulk copy into multiple tables I am currently importing xml data into SQL2005 using openrowset.  It works fine but is very slow. My xml has multiple tags with data t be inserted into different tables e.g. Order, Orderline   I am hoping to find a faster solution and looked i	asked 5/4/2012 7:15:14 PM by Fleur 2 answers
sp_updatestats except for some tables How to run sp_updatestats except for some tables in a user defined database.	asked 5/4/2012 3:31:08 PM by ranjith 1 answers
rollback status on sp_who2 Hi,   I was doning the alter table for droping constraint , than recreation of index..men while i got error datafile does not have sufficient space. i ignored that message. than i fired sp_who2 , it was showing rollback in status coloumn for that	asked 5/4/2012 11:54:41 AM by adveet 0 answers
list data in colums Hello, i want to list data in 5 colums example: select name from table X result normaly = name1 name2 name3 ect. i want name1 name2 name3 name 4 name5 name6 name7 name8 name9 name10 ect. How can I do that ??	asked 5/3/2012 4:55:20 PM by JA.Veldkamp 4 answers
MigrationTypes Hi All, Could you please explain about Migration types ?	asked 5/3/2012 3:28:22 PM by VekateshRoyal 0 answers
trouble shooting issues what are common issues in logshiiping for prodduction dba?	asked 5/3/2012 6:56:15 AM by sai 0 answers

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

Sponsor Information

Try the award winning SQL diagnostic manager as a free 14-day trial! SQL Monitor – For database professionals who need results on Day One. Try it online. What grade do you think your SQL Servers get? Find out with a SQL Server Health Check consultant. Find and Fix SQL issues with Foglight Performance Analysis. Get a free copy. Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Demystify TempDB Performance and Manageability