Viewing 15 posts - 29,506 through 29,520 (of 49,552 total)
goodguy (11/8/2010)
For performance purposes, since I do not use SQL Server a lot, I have not set SQL services to launch at startup. 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 8, 2010 at 2:18 am
Harshana-680014 (11/7/2010)
when I changed the Table Data type in column, it doesn't allow to save in SSMS 2008 R2.see the attached image or http://micro.harshana.net/day/2010/11/08
Not a bug, a feature. It's 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
November 8, 2010 at 1:25 am
What do you have in the services tool? (Administrative tools-> services)
I can't tell what those are and the sizes make me think that none are the database engine (far 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
November 8, 2010 at 1:22 am
You need to drop the four objects listed in the error messages. Query sys.objects to see what they are, then look up in Books Online how to script and drop...
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 8, 2010 at 12:46 am
Post the deadlock graph? Without seeing it, it's hard to explain it.
There are lots of resources available to help if you want to do it yourself. Google should turn 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 recoverability
November 8, 2010 at 12:45 am
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 recoverability
November 7, 2010 at 3:54 pm
Concatenate them into the string instead of putting the names. Remember what the scope of the variables is - inside or outside the dynamic SQL, not both. Please go and...
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 7, 2010 at 3:10 pm
The errors are pretty clear. You've got objects that depend on the collation. You cannot change the collation without removing the objects first. Where's the problem?
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 7, 2010 at 3:06 pm
murali100 (11/7/2010)
can someone tell what is wrong?
Without you telling us what the error was, no.
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 7, 2010 at 2:50 pm
There are features that changed and things that got removed. You should test carefully on SQL 2008 before upgrading.
Be aware once you attach a SQL 2005 DB to SQL 2008...
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 7, 2010 at 2:49 pm
The problem is that you're trying to use RETURN.
Return is (typically) for the result code for a proc (0= success, etc) and it is always an integer. Rather use either...
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 7, 2010 at 2:33 pm
ColdCoffee (11/7/2010)
How about this?
SELECT Col1 + SPACE(32-LEN(Col1))
That can result in a string longer than 23 characters if there are already trailing spaces.
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 7, 2010 at 12:14 pm
goodguy (11/7/2010)
I was just stating the easy approach many developers go for,
I'll be blunt. That 's not the 'easy' approach, it's the lazy and irresponsible approach. Anyone who considers...
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 7, 2010 at 12:13 pm
EXEC (@sql)
That variable need to hold the use <dbName> AND the Shrinkfile, otherwise you'll just be shrinking master's log repeatedly. The USE within the dynamic SQL only has effect within...
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 7, 2010 at 12:03 pm
sysindexes for the indexes (will need a join to sysobject or the object_name function to get the table name)
sysobjects for the constraints (will need a join to sysobject or the...
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 7, 2010 at 8:41 am
Viewing 15 posts - 29,506 through 29,520 (of 49,552 total)