we have a requirement in sql server to write a script in extracting numbers from alphanumeric string. I have looked at char-index and patindex but...
i remember till last year your site encouraged users with prizes. i dont see that here for a long time, what is the reason? i feel that is good to...
i have a query that returns successful results getting the distinct id from a enquireies table as follows: select DISTINCT enq.enqid, enq.empid from...
i have been enjoying this forum with some cool and funny posts over here, what happened no one seems to be posting any more here.
first of all i appreciate all members here who are helping other dbas in world to save their work. Especially i can see a bunch of experts...
could someone help me to capture online performance monitor statistics using sql queries without using sysmon tool. any script will help a lot....
Where can I find documentation about cluster?
I have used dbcc shrinkfile on a server which worked well to reduce the Transaction log to the desired size. We have specified values to set tlog...
On one of my sql 2000 with SP3 machine using Fastfirstrow option hint in select clause is not working? Has anybody got valid references to point me...
What is the default order for index creation? If its ascending then how to create another index with descending order? Thanks.
I have to capture counters for Analysis services at my office. I couldn't find documentation or information about what counters to be collected. How...
Hi Forum I am back with set of questions. I am having trouble reading values from a column which is text datatype. Could somebody help me to get the...
What is the best value for fill factor on indexes?
At one instance I tried to PAUSE one SQL server service for some administrative tasks. I was unable to pause, what is the reason behind this. I had...
Forum There is a command to know which SQL Server(s) are running over network, I was unable to recollect. Could someone provide the link. Thanks...
We are going to implement merge replication on one of the service, before hand I would like to have information on performance of merge replicaton....
I am aware about accessing SQL server error logs from enterprise manager and from command prompt. Is there any way I can read the same using stored...
Forum I am getting following error when trying to capture few counters in perfmon. The description for Event ID (1001) in Source (SQLCTR70) could...
Forum I am having issue when installing SQL Server 2000 latest service pack3, I am getting Access Violation errors and couldn't find any reference...
How to script the database objects, I need to clone few database objects to a remote server for testing purpose. Also will it be possible to script...
Separate names with a comma.
