Hi Group, *Great News For Hyderabadi Techies!* MUGH -SQLCON is going to launch a *SQLServer Whitepaper contest* very soon (from Sept 7th). We hope to see...
Hi Group, Great News For Hyderabadi Techies! MUGH -SQLCON is going to launch a SQLServer Whitepaper contest very soon (from Sept 7th). We hope to see maximum...
No I have only one server. Ved Prakash Agrawal <ved_17in@...> wrote: RPC (remote procedure calling) before provide the answer of your question , I want...
Hi Santosh thanks for response... no i could able to start server from cmd line and if try then the same error appears. how can use sysinternals??? regards ...
Dbcc Inputbuffer for all the System and backGround Processes Gives you Noevent and msdb related sqlserveragent spid's given you language event and the thing...
Hi, I am using Yukon Beta 2 Analysis services. I have couple of Cubes and related dimensions. I access these using MDX query from web application. In the Roles...
Dear all, 1. pls tell me the difference between procedures & functions with a suitable example. 2. Pls send me the query for how can i select first 500 rows...
Hi, Sysinternal is not a standard windows tool. It is a third party free to download tool(reliable one). you can seach in google and download that tool. Did...
Uday , Procedures can be considered as Batches of sql statements that can do lot of miracles .Most of the miracles are documented in BOL. Functions need to...
Hi Refer to this article which explains how to move master database http://www.databasejournal.com/features/mssql/article.php/3379901 i would recommend try to...
Hi, Did you check whether the SQL Server is running in services and it gets started automatically with the windows. If so put those sql server related services...
Hi I like to use performance monitor tool in windows server to monitor sql server performance.Regarding this i get details of sql server in performance objects...
Enter your vote today! A new poll has been created for the sqlcon group: Is SQLWIZ Contest a step in the right Direction ? If Not please email us your...
sqlcon@yahoogroups.com
Sep 2, 2005 9:52 pm
1337
Hi, How i will all delete duplicate rows in sql server in a single shot. Thanks Harsh __________________________________________________ Do You Yahoo!? Tired...
Hi Vishnat, thanks a lot for ur immediate response.I really feel this will help me out to understand the concepts very well. with regards & thanks Uday VISHNAT...
Hi, You can use following script. SET ROWCOUNT 1 DELETE yourtable FROM yourtable a WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.name1 = a.name1 AND b.age1 =...
We usually use a customized script and I found a link as well steps to same... ==================================================================== This method...
HI , There is 2 ways to delete duplicate rows........... I am using three fields in table ... 1. SELECT DISTINCT fieldname1,fieldname2,fieldname3 INTO #TMP1 ...
 Check this link http://www.sqlteam.com/item.asp?ItemID=3331 Regards Raghs ... Check this link http://www.sqlteam.com/item.asp?ItemID=3331 Regards Raghs...
hi , ans 1 . The main Difference is procedure and function is function can used in a select statement but procedure can't use. ans2 . select identity (int ,...
... I hope you have got enough mails regarding UDF and SPs. I would like to mention the performance issues of UDF here. We initially used a lot of UDF in our...
Hi All, MUGH 's SQLServer Whitepaper Contest ' SQLWiZ' starts today. For contest rules & more details on the contest visit www.mugh.net/techfest So, rush your...
The following sqlcon poll is now closed. Here are the final results: POLL QUESTION: Is SQLWIZ Contest a step in the right Direction ? If Not please email us...
sqlcon@yahoogroups.com
Sep 7, 2005 8:08 pm
1348
SQL 2005 - OPTIMISATION AND DEVICE MANAGEMENT Biswajit Das System Analyst(05) Microsoft.GDCI.FOIT __________________________________________________ Do You...
hi , what is the means of NULL? any one can define NULL value. (I know that the value of NULL is unknown.) this can affect the performance or not. if yes then...
Hi All I need to be setup ongoing job of replication of some tables from production database to another databse. job need to running in every 1 hour. It is...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
