Hi Satya, Good reference. I am composing a script which drops and recreates constrainsts / indexes which dependant of collation columns. Now I can...
quote: Originally posted by ranjitjain I think i can use this to replace xp_getfiledetails But what command is there in DOS to get file details. I'm...
If the server is configured with dynamic memory allocation, we can monitor the memory usage by SQL Server through perfmon counter, SQLServer:Memory...
Check the Data Access option value for the linked server SERVER2. In case the option was disabled, enable it. You can check this value from...
I guess the user has DBO rights in his database. DBO right in a database is not enough to view / monitor the scheduled jobs. If a user is not an...
If your database is in Full recovery mode, then the best way is backing up the transaction log, truncating the unused space and taking full /...
So, maximum possible databases (theoretically) in a server are 524,272. (16 instances * 32,767 databases) [8D] /* SKChandra */
It is a set of processes which tells how we are handling / implementing changes in our production environment. In general any changes should go...
From the link: quote:Autoclose option is not recommended for production systems since it can be a significant performance impact. Apart from the...
<br />When we have problems in scheduled job in SQL Server, these are the checklists to be reviewed.<br /><br />1)Check SQL Agent service is...
Placing heavily accessed tables in one filegroup and the table's non-clustered indexes in another filegroup on different physical disk can improve...
Play with this scriptlet select serverproperty('collation')[Server collation] ,name [Database Name] ,databasepropertyex(name,'collation')...
Hi, Could you possibly tell me what is the impact (security, performance) of .Net framework installation on a production SQL Server 2000. Thank...
The in-built trace template 'SQLProfilerTSQL_Duration' will be useful for finding long running queries. quote: From Books On Line: Find the...
Here is the link, which talk about ODBC setup for MySQL and accessing MS-Access. http://www.gsp.com/support/virtual/mysql/odbc/ Some good link...
What are the differences between OLTP DBA and OLAP DBA in terms of:<br /><br />Area of skills require<br />Job responsibility<br />Using their...
Specified columns in WHERE clause and in JOIN clause are mostly determines index seek and index scan selection. "Index Seek" can be used when we use...
Hi friends, The requirement is not a business requirement. Just I asked to know that is there any way to achieve it. Thanks Twan. I will try that...
<br /><b>>sum((r.price1 - r.price2) * case (c.CampaignType)<br />>when 1 then r.clicks<br />>when 0 then r.Impressions<br />>end</b><br...
Yes. I agree with you. We can store the original value into a variable or after update statement, we can read the old data from 'deleted' pseudo...
Separate names with a comma.
