Dear All, I wish you a happy and prosperous New Year.... Kishore. ... Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping [Non-text portions...
Hi All, I need a query to convert getdate() result to Year-Week format : For example Select getdate() will return 2006-01-01 21:12:53.557, since it is Jan 1st...
Hmmm. Here's the kludge (You know Monday morning and first working day of the year. Cant think properly :) SELECT x + CASE WHEN LEN(y) = 1 THEN '0'+ y ELSE y...
Hi here is my query for getting the Information from maintenance plan, But this query retrive multipul rows, i want to sortout by the start time. please help...
HI Roji, Can you let me know the importance of 'T' in the syntax. Kishore. "Roji. P. Thomas" <thomasroji@...> wrote: Hmmm. Here's the kludge (You know...
Just try it without 'T'. You will see why its required. Regards Roji. P. Thomas ... From: kishore To: sqlcon@yahoogroups.com Sent: Monday, January 02, 2006...
use profiler. rajans22in <rajans22in@...> wrote: how to read the trace file which are stored on disk. ... tracing. ... http://www.mugh.net ... SqlCon...
Hi, You can go for PSSDIAG which is backend tool. If you run normal profiler it effects the performance of the production server. Regards, Kishore. ...
Hi, Try this SELECT CONVERT(VARCHAR(4),YEAR(GETDATE()))+ RIGHT ('0' + CONVERT(VARCHAR(2), DATEPART(wk, GETDATE()+ 61)), 2) uses only one string function ...
Hi All! I created table and one column datatype is float. I inserted values into float column 5.3. but when i wrote a select statement it is displaying...
Shyam, Float is an "approximate" datatype, not exact. So it stores the nearest possible value. If you want the values to be exactly accurate, you mant to...
Hi, I have set up transactional replication, in which I have a case like consider tableA in server1 and tableA and tableB in server2. Server2 is the...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the sqlcon group. File :...
sqlcon@yahoogroups.com
Jan 4, 2006 5:21 am
2257
Hi, I get an error *"Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).* " while...
Hi ALL, How can we arrange the table in the Dependency Sequence? e.g. IF one table (called A) has primary key and A table refer to some other table (TableB)...
Hi Ved, The following script list all tables according to their dependency order. Hope it will solve your problem. declare @Rows int, @LevelID int declare...
Hi Neeraj, When I trying to execute this query, it goes into infinite loop... please check.. Ved ... order. ... TableName from ... which ... Service....
Hi Friends, The good practise as a programmer while doing database operation is to open the connection when it is needed and then immediately close the...
This paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as SQL Server...
Bhavesh, The following query will give you the details of 'sleeping' connections. select spid, dbid, RTrim(hostname) as hostname, LEFT(program_name,12) As...
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.
