Description:
Microsoft's SQL Server and related products.
|
|
|
Hi Experts i have doubt
|
| |
have MS SQL 2008 R2, 500 databases. What is the most efficient, easiest and 'modern' way to query all databases sizes.
The output should have columns:
•DatabaseName
•DataFilesSize
•LogFilesSize
|
|
|
Hi
|
| |
Hi Experts
can u send Sqlserver dba & ssis material for me
|
|
|
Hi Experts
|
| |
i have some doubts please clarify
1. What is the difference between cluster installation for SQL Server 2005 and SQL Server 2008?
2. Log shipping has been set up new and is running fine. All on a sudden during the after hours, it starts failing. What could be the possible reasons?
3. There is excessive performance issues on a database server. What are the steps taken for the analysis and resolution?... more »
|
|
|
Extracting nth word in a string
|
| |
Hi,
Please, can you help me how extract nth word in string ccs.errormessage ?
Select n.caption, ccs.errormessage FROM APM_CurrentComponentStatus ccs WITH (NOLOCK)
INNER JOIN APM_Application a WITH (NOLOCK) ON ccs.ApplicationID = a.ID
INNER JOIN Nodes n WITH (NOLOCK) ON a.NodeID = n.NodeID
where ccs.ErrorMessage LIKE '%hit%'... more »
|
|
|
Query doubt
|
| |
Hi,
Please help me solve my doubt.
When I execute this query:
Select n.caption, ccs.errormessage FROM APM_CurrentComponentStatus ccs
WITH (NOLOCK)
INNER JOIN APM_Application a WITH (NOLOCK) ON ccs.ApplicationID = a.ID
INNER JOIN Nodes n WITH (NOLOCK) ON a.NodeID = n.NodeID
where ccs.ErrorMessage LIKE '%atingiu%'... more »
|
|
|
Some questions about relational indexes and statistics in SS2005
|
| |
I have some questions about relational indexes and statistics in Microsoft SQL Server 2005, mainly Standard or Enterprise Editions.
This is in the context of improving indexes and statistics in many copies of a database that wasn't designed by me, and in which many tables are dropped and re-created by stored procedures overnight,... more »
|
|
|
SQLfly New Generation Database Tool
|
| |
SQLfly is a database management, schema/system compare, database quality reports and database query tool to make every day work more productive. Currently supports ORACLE Databases (Oracle 9i, 10g, 11g). SQLFLY provides both Desktop and Mobile version of the products to access database anywhere, anytime!... more »
|
|
|
How to find not-committed transaction in SQL Server 2008 exactly?
|
| |
My C++ code accesses SQL Server by ODBC driver 2.x, and calls
SQLSetConnectAttr( pMSSQLHandles->hDbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, 0 );
to set the transaction to implicit transaction. I also call SQLEndTran() to commit the transaction.
After my application starts， in SQL Server 2008 Managment Studio, run "DBCC OPENTRAN", no active open transaction is reported. And "select @@TRANCOUNT" return 0.... more »
|
|
|
need help with ordering groups of records
|
| |
I have a list of customers and addresses they have visited, each record has a count of visits. I need to re-sort the list in such a way that customers with higher counts will be higher on the list, but all his/her records should stay together
To illustrate:
declare @T table ( ID int, NAME varchar(32), ADDR varchar(32), CNT int );... more »
|
|
|
