Viewing 15 posts - 47,941 through 47,955 (of 49,552 total)
As far as I know, if the SQL Server is on a domain, the domain's password policy is the one that's enforced. If the server's not on a domain, then...
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
December 24, 2007 at 1:30 am
Did you copy the database from the other server, or just the proc?
The server's default colation only affects the system databases and new databases created on that server. Databases copied...
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
December 24, 2007 at 12:47 am
Is the collation of the 2 servers different?
It looks like one is case sensitive and one is case insensitive. Is that deliberate, or should both servers be the same?
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
December 23, 2007 at 11:43 pm
In addition, corelated subqueries in the select caluse can result in poor performance as, depending on the plan chosen, SQL may have to execute each subquery once per row 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
December 23, 2007 at 11:32 pm
I'm quite fond of the Inside SQL Server 2005 series from Solid quality Learning. They're not beginners books though.
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
December 23, 2007 at 11:12 pm
I can't see anything obviously wrong with the code, but then I'm not a C# expert, so I may have missed something.
What I'm curious about is why you're using 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
December 23, 2007 at 10:25 am
And to you and your family
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
December 23, 2007 at 5:42 am
Ok, so given what I said above, if, using the example I wrote, you had to find a person with a specific phone number, how would you like the phone...
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
December 23, 2007 at 3:43 am
It is a Saturday. Normal people don't frequent work-related boards over a weekend
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
December 22, 2007 at 8:37 am
I watched Stardust a couple weeks back. Brilliant movie. I must get the DVD. Haven't watched any of the Borne movies, but I do intend to.
At the moment I'm reading...
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
December 22, 2007 at 2:49 am
Very important. Queries can only seek on an index if the columns that are in the filter are a left-based subset of the index.
Look at it this way. If you...
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
December 22, 2007 at 2:42 am
Too easy?
Ah well, we are here to help people out after all.
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
December 22, 2007 at 2:15 am
You can select them and return then as a recordset.
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
December 21, 2007 at 2:59 pm
Edit. I need to read better.
A better way to debug than mess with dynamic SQL, which in this case is going to cause errors that didn't exist before, is to...
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
December 21, 2007 at 2:32 pm
Take this lot out from just before the exec. The GO breaks the batch and afterwards, the SQL1... variables are not defined.
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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
December 21, 2007 at 2:22 pm
Viewing 15 posts - 47,941 through 47,955 (of 49,552 total)