solving sql server problems for millions of dbas and developers since 2006



SQL Server DBA Tips SQL Server Developer Tips SQL Server Business Intelligence Tips SQL Server Career Tips SQL Server Whitepapers SQL Server Tools SQL Server Webcasts SQL Server Questions and Answers SQL Server Questions and Answers












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


Copyright (c) 2006-2012 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.


Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com