Viewing 15 posts - 15,331 through 15,345 (of 49,552 total)
mani@123 (12/7/2012)
I am talking about indexex(Starts With _WA_) these are automatically created right?
Those aren't indexes. They're automatically created statistics.
You can update then using the UPDATE STATISTICS 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
December 7, 2012 at 8:34 am
Files cannot be moved between filegroups.
If you want to move partitions of a table to a new filegroup, you'll have to create the new filegroup, create files within it 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 7, 2012 at 8:33 am
Remove the USE statement, as the error said, the CREATE must be the first statement in the batch.
When you set up the connection string and open the connection you can...
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 7, 2012 at 6:34 am
Can you be any more specific about the kind of problems it's causing?
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 7, 2012 at 6:17 am
Well I can't figure out what problem you have with the procedure and I gave you a suggestion on how to check that a column exists. If you can give...
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 7, 2012 at 6:11 am
Firstly go and do some reading on .Net error handling and proper ways to handle errors. Your update could fail because the DB's unavailable and still you'd tell the user...
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 7, 2012 at 5:32 am
If the web page stops rendering but SQL's OK, I would be looking at IIS (or whatever your web server is), not SQL.
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 7, 2012 at 4:37 am
jerome.morris (12/7/2012)
I do have a check like this:
try
{
...
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 7, 2012 at 4:36 am
Your caps lock appears to be stuck, and I don't appreciate being shouted at...
Now, can you explain in a little more detail what you're trying to do here?
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 7, 2012 at 3:33 am
Bombs out with what errors?
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 7, 2012 at 2:53 am
What do you mean by 'allocated CPU'?
The CPUs that SQL can use? If so, check the processor options for the affinity. It's all processors unless you set otherwise.
The amount 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 7, 2012 at 2:51 am
jitendra.padhiyar (12/7/2012)
But I want to know reason why it was offline.
Somebody connected to the server and ran ALTER DATABASE ... SET OFFLINE
SQL doesn't set DBs offline by itself. What 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 7, 2012 at 2:49 am
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 7, 2012 at 2:46 am
Ok...
Open the SQL Server configuration manager, find the instance in question (Express), right click-> properties, go to advanced, look for the startup parameters, copy whatever's there and paste it here.
When...
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 7, 2012 at 2:44 am
Chris Becker (12/6/2012)
Right-click db | Properties |...
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 6, 2012 at 3:55 pm
Viewing 15 posts - 15,331 through 15,345 (of 49,552 total)