Viewing 15 posts - 43,096 through 43,110 (of 49,552 total)
Why do you want it in a standby state?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2008 at 8:53 pm
J (11/14/2008)
A developer used code like this, before SQL Injection was exposed:[font="Courier New"]DECLARE @sql varchar(200)
SET @sql = 'SELECT somefield FROM sometable WHERE PersonName LIKE '%' + @data + '%'[/font]
As a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2008 at 8:25 pm
Generally you'd use a composite key if there is no single column that uniquely identifies the row.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2008 at 8:20 pm
Depends. What does the proc do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2008 at 8:13 pm
viji (11/14/2008)
It doesn't take much time when it runs from SQL Server.
Could be a parameter sniffing issue, could be a few other things. Best thing to do here is run...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2008 at 8:04 pm
Restore the database from a backup taken before you deleted from the system tables. There's no other way to put the row back.
By modifying the system tables you have severely...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 9:15 am
sp_helpindex for indexes on a table, or use sys.indexes and sys.index_columns to get all of the indexes in the DB
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 9:11 am
One thng to bear in mind. In SQL Server triggers are not fired for each row that's inserted/updated. They fire once for an insert/update/delete operation and the inserted and/or deleted...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 9:10 am
Schadenfreude-Mei (11/14/2008)
Does that sound right to you Gail?
Wouldn't know. As I said, you'll have to ask someone who knows sharepoint well, and that someone is not me.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 9:06 am
No need to disable any distribution agents.
SQL with or without replication can handle expected or unexpected shutdowns without data loss.
With replication, the data to be replicated is copied from...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 9:04 am
Depends on where I am and what I'm doing. If I'm away on business and working with a client, I can often do 9 or more hours of work a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 9:00 am
It could be that for some reason SQL couldn't identify the locked resource. I have seen that from time to time. If you get an answer, please let us know.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 8:49 am
GermanDBA (11/14/2008)
I'm not sure If I read the details incorrectly, but the new policy manager for SQL 2008 should supply just this. You setup the policies it should check...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 8:40 am
Shripad (11/14/2008)
Dear ,I have checked all DBCC commands, i am getting same error as i mentioned earlier.
Please post the full output of the checkDB command that I gave above
I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 1:58 am
Depends how fast the indexes fragment. If you have an index where the fragmentation increases about 2% a month, then reindexing weekly is too often. If you have an index...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 12:55 am
Viewing 15 posts - 43,096 through 43,110 (of 49,552 total)