Viewing 15 posts - 23,911 through 23,925 (of 49,552 total)
You can't create a nonclustered index with a varchar(max) as the key column. You can put a varchar(max) as an include column, but if you try to create 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
August 25, 2011 at 11:39 am
Kiara (8/25/2011)
Sadly, my dojo time is what had to go. I've promised myself when the NoLongerSoSmallPerson is out of high school, I get to go back. And start over. 🙂
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
August 25, 2011 at 10:54 am
😀
CLR not enabled != no CLR in use.
Some of the internal stuff uses CLR without needing CLR to be explicitly enabled.
General rule of thumb here. if SQL is using too...
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
August 25, 2011 at 10:49 am
Kiara (8/25/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
August 25, 2011 at 9:57 am
Doesn't matter, max server memory takes effect without any restart necessary.
SQL is not ignoring the limit. The max server memory sets the size of the buffer pool (data cache, plan...
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
August 25, 2011 at 9:52 am
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We should refrain 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
August 25, 2011 at 9:49 am
Brandie Tarvin (8/25/2011)
Ninja's_RGR'us (8/25/2011)
Talking about narrow minded... will he every shut up?I'm confused. What's wrong with the answer to the question?
It's SanDroid whining again. Probably a preposition out of...
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
August 25, 2011 at 9:15 am
I would strongly recommend that not be done in a trigger. Rather the procedure that creates the user should insert the activity as well.
Still, you're either going to have...
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
August 25, 2011 at 9:14 am
Tom.Thomson (8/25/2011)
I saw this in an SS Central topic, and responded appropriately - I hope. If anyone thionks I was inappropriately heavy, let me know.
Grrr. What a narrow-minded view....
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
August 25, 2011 at 8:55 am
Saga... (8/25/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
August 25, 2011 at 8:52 am
Now that's a lot, lot more difficult.
Why? What's the reasoning here for why a single trigger should behave differently depending on who did the 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
August 25, 2011 at 8:45 am
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
August 25, 2011 at 8:37 am
Original_Login() will get you the login name for the current connection.
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
August 25, 2011 at 8:28 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
August 25, 2011 at 8:22 am
chandan_jha18 (8/25/2011)
i know that view has no lock hints. Getting rid of it did not help much in my performance so i have left it the way it was designed.
Getting...
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
August 25, 2011 at 8:18 am
Viewing 15 posts - 23,911 through 23,925 (of 49,552 total)