Viewing 15 posts - 32,896 through 32,910 (of 49,552 total)
Alvin Ramard (5/13/2010)
Steve Jones - Editor (5/13/2010)
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
May 13, 2010 at 9:35 am
steve block (5/13/2010)
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
May 13, 2010 at 8:26 am
70 pages is a fair bit. My entire Master's dissertation will probably only be around 70-80 pages.
What interests you in databases, within the areas that the lecturer set? I ask,...
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
May 13, 2010 at 7:56 am
I'll see if I can repo it.
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
May 13, 2010 at 7:46 am
tony.turner (5/13/2010)
GilaMonster (5/13/2010)
If, however there is an ORDER BY, and SQL can use an index to retrieve the data ordered, it avoids a sort operation.
As I understand the section in...
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
May 13, 2010 at 7:21 am
There's no audit table by default.
You'll need a server-side trace if you want this in SQL 2000 as well as 2005/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
May 13, 2010 at 6:48 am
Connect time I think. There's either a bug in the docs or in the code.
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
May 13, 2010 at 6:47 am
How long is a piece of string?
Seriously, there's no way, just from the size of the DB, to make any educated guess as to the time to shrink. Depends on...
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
May 13, 2010 at 6:42 am
rdouglas66 (5/13/2010)
Wow, a reply from Gail I'm honoured
Why?
I've had a look at the counts on our main prod server and there are 28 (all returning 2 rows) 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
May 13, 2010 at 6:35 am
rschaeferhig (5/13/2010)
I didn't know if anyone had a way to actually update the View_Definition (whereever it is stored) that you can read from Information_Schema.Views...
Nope. System tables cannot be updated.
Script,...
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
May 13, 2010 at 5:36 am
karthikeyan-444867 (5/13/2010)
SELECT race,SUM(POSITION('male' IN sex) AS male_tally,
SUM(SIGN(ABS(POSITION('female' in sex) AS female_tally
FROM Personnel
GROUP BY race;
That's not SQL Server code. A very quick google search reveals that PostgreSQL supports that function.
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
May 13, 2010 at 5:23 am
Multiple statements within a procedure? Query stats works that way, I'll admit I've never used procedure_stats.
Check one of the procedures that has multiple rows, see how many queries it has...
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
May 13, 2010 at 5:20 am
Ok, so the DB is attached but suspect. Please run the following.
ALTER DATABASE <database name> SET EMERGENCY
Once you've done that, you should be able to access the DB, though it...
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
May 13, 2010 at 5:16 am
Full table definitions (the create table statement) and index definitions please (all indexes). See the article that Dave listed.
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
May 13, 2010 at 5:14 am
I asked about the upgrade message. Is the SQL instance that you're trying to recover this with IDENTICAL to the version that this DB was attached to before the SAN...
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
May 13, 2010 at 3:26 am
Viewing 15 posts - 32,896 through 32,910 (of 49,552 total)