Forum Replies Created
Viewing 15 posts - 29,491 through 29,505 (of 49,552 total)
-
RE: why is this taking ages?
Could be related to different SET options, though I don't know how to tell what the default options are for a connection from PHP (ansi nulls, arith abort, etc)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: why is this taking ages?
BenWard (11/8/2010)
do I have to give the KPIuser account permission to use indexes?No.
Edit and change to code:plain, it'll look better.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: why is this taking ages?
Run profiler, see what the exact call is that PHP is making to SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Rebulid Index is failing with error
Did you read the error?
Sqlsavy (11/8/2010)
"Could not allocate a new page for database 'D_DATAMINE' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Single SELECT
Bhuvnesh (11/8/2010)
i need above output with SINGLE "select" keywordscant use double "select" like below queries
Why? What's the reasoning behind that odd limitation/restriction?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Database drops
imSQrLy (11/8/2010)
My question is, is a drop\delete of a database logged anywhere by default?In the default trace (that's what it's there for)
The highlighted two rows (straight from the default...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Moving database files in cluster environment
As long as all the drives involved are dependencies of the SQL Server service, there are no special considerations for moving files in a clustered environment.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 2005 instance on 2008 Front end
goodguy (11/8/2010)
MSSQLSERVER
SQLEXPRESS
I would guess that the MSSQLSERVER is the 2005 instance and SQLEXPRESS is the 2008 express instance (from earlier results from @@version and comments)
Where it is in the installed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: DBCC Opentran returns non numeric SPID(14s) and OLDACT_NAME = NoLongerClean
Adiga (11/8/2010)
This is the SPID that indicates there a few transactions to be replicated on that databaseNot quite. (no spid in sight)
The LSNs indicate that transactional replication is set up...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SSIS 2008
Speak to your DBA and ask him to grant appropriate logins and permissions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: log backup failed
Please explain your question more.
Are you asking why a log backup failed or are you asking how to find when someone broke the log chain (by a switch to simple...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Problem:: SSIS: Excel Destination. Mapping columns dynamically
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1017043-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Problem:: SSIS: Excel Destination. Mapping columns dynamically
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1017043-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: multiple update
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: restrict log file size -sql server 2005
T.LOGANATHAN (11/8/2010)
My DB recovery model is FULL and I am taking full backup on every day and transfer the backup to other server ( for Precaution)That's not sufficient in full...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 29,491 through 29,505 (of 49,552 total)