MSSQLTips

hi everybody, I am facing one problem while executing the query the size of temp database increasing at rapid speed and the size of data file become 15 gb from 500 mb and then it stuck as the space of c drive get full. before that query was running gud but it was taking only 5 min. i tried the tuning...

How I can get a list of all my login (User login - login with name which not start with prefix like : ## , $ ,sa,BUILTIN ... ) throw SQL code. Thank you .

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

I was fortunate enough to have been invited to speak again at the SQL Server Club, which is a Quest sponsored event, focused on Enterprise-class SQL Server topics. The focus of this event was SQL Server Performance and it was thoroughly enjoyable presenting sessions alongside all round nice guy and SQL...

How to Improve performance on partion View? I have partition view that will fetch data by having union all to 9 database tables. All 9 databases have same table and schema structure on same instance. At the background, this tables keep loading new data for every 1 min to all 9 databases through...

Hi. I'm kinda new to the index world, but I ran the Dashboard report on my database so I can improve the efficiency and the list of missing indexes are listed below. My questions are, why are some repeated, and can any of them be combined (like [dbo].[PlantEquipmentSignal] ([EquipID]) [dbo].[PlantEquipmentSignal...

How to write stored procedures in SQL Server? Please Send the Description with examples of stored procedures. How many types of stored procedures are there in SQL Server for INSERT,UPDATE,DELETE? How to call procedures?

I am having doubt - is it achivable Or not? The senario is , "If the outer transaction is rolled back, then all inner transactions are also rolled back" is it any way to avoid Rollbacking of inner transactions?? Thanks, srinivasan r

In the next link, http://www.mssqltips.com/tip.asp?tip=1541 , there is a paragraph where it mentions that clustering in SQL server is about availability, opposite about others setups about incresasing power processing; Is there something about it (clusters for add power processing) in SQL Server (perhaps...

Hi, Do anyone can confirm me, i am little bit confused whether using alias name will improve the performances Or not? In my point of view, it won't do. Because i observed one thing by the CPU time & elapsed time is less, when i did not use alias name in my query. If it's not Helping to improve...