Viewing 15 posts - 25,786 through 25,800 (of 49,552 total)
Try copy the file locally and then restore
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
June 2, 2011 at 3:15 am
Are you absolutely certain there's no trigger? Query sys.triggers
SELECT * FROM sys.triggers AS t WHERE parent_id = object_id('tb_inspiration')
The insert you posted works fine for me...
CREATE TABLE tb_inspiration (
InspirationID int NOT...
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
June 2, 2011 at 3:14 am
The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that...
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
June 2, 2011 at 3:08 am
Rich Yarger (6/1/2011)
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
June 2, 2011 at 3:07 am
Depends. What are you doing in those CLR assemblies?
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
June 2, 2011 at 2:53 am
Steve Jones - SSC Editor (6/1/2011)
DBCC JobChange ('<html><submit url="www.dice.com" attach="resume.doc">')
Except that throws an Invalid Region Exception.
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
June 1, 2011 at 4:13 pm
jcrawf02 (6/1/2011)
"What do you get when you cross a mountain climber and a mosquito?
Nothing, you can't cross a scalar and a vector!"
Wut? How is 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
June 1, 2011 at 4:12 pm
First thing to note is that AND takes precedence over OR. So what you wrote there is evaluated as:
SELECT *
FROM Table
WHERE (Column1 = @Column1 AND Column2 = @Column2)
OR @Column2...
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
June 1, 2011 at 4:09 pm
That would require some very complex XQuery, including the XQuery XML modification operators. Not quick, not easy.
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
June 1, 2011 at 1:05 pm
There's no such thing as an incremental backup in SQL Server.
There are full backups, differential backups and transaction log backups.
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
June 1, 2011 at 1:01 pm
DBCC RunLikeHell
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
June 1, 2011 at 12:59 pm
Great, not go back and look at Ninja's comments on this trigger.
It will NOT work properly if more than one row is affected by Insert.
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
June 1, 2011 at 11:47 am
Missed that.
Ok, for the rest, replace the EXEC with Print (and remove the brackets) and post the printed out statement
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
June 1, 2011 at 11:27 am
Krasavita (6/1/2011)
What is better to use numeric or integer in the table, which takes less space?
It's got nothing to do with space and everything to do with what you're storing....
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
June 1, 2011 at 11:21 am
exec (@var1)
Need brackets or the contents of the variable are interpreted as an object name.
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
June 1, 2011 at 11:20 am
Viewing 15 posts - 25,786 through 25,800 (of 49,552 total)