Viewing 15 posts - 21,301 through 21,315 (of 49,552 total)
Perry Whittle (1/5/2012)
Granting CONTROL at the schema level is quite brave IMHO 🙂
I could use a few other words than 'brave' I think 🙂
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
January 5, 2012 at 2:04 pm
Ok, so what are you after?
Partitioning can improve performance, but it's far from an automatic thing, depends on how queries are written, how the data is split up. The more...
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
January 5, 2012 at 1:56 pm
CELKO (1/5/2012)
This is only one reason why good SQL programmers never use this proprietary non-relational "feature" in their code.
Blah, blah, blah.
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
January 5, 2012 at 12:23 pm
David Moutray (1/5/2012)
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
January 5, 2012 at 12:19 pm
Both of those are under the threshold where one would worry at all about fragmentation (that's around 1000 pages).
A shrink job would cause massive fragmentation. Are you absolutely sure there...
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
January 5, 2012 at 11:53 am
When I interview people, I'm after technical ability, eagerness to learn/improve and a fit with the team/position (and a lack of outright dishonesty about their abilities). I couldn't care 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
January 5, 2012 at 11:46 am
p.s. Is autoshrink on? Is there a daily job shrinking the database?
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
January 5, 2012 at 11:37 am
David Moutray (1/5/2012)
The table has about 10,000 records.
Not interested in the number of records. How many pages does that index 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
January 5, 2012 at 11:36 am
Ok, have a look in the error log for any 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
January 5, 2012 at 11:36 am
ajsnyman (1/5/2012)
To be honest, it seems I do not understand the function of the CONTROL permission.
Full and complete permissions to the object and anything within it. (for example, a sysadmin...
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
January 5, 2012 at 11:34 am
Ninja's_RGR'us (1/5/2012)
GilaMonster (1/5/2012)
Ninja's_RGR'us (1/5/2012)
It's almost like they want to punish you for daring asking for money and making sure you NEVER ever want to go through that process ever gain.
At...
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
January 5, 2012 at 11:32 am
Tara-1044200 (1/5/2012)
It is taking too long for connecting to the server from managment studiio
Is it timing out or giving an error?
andfrom the event log i see this message "Starting...
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
January 5, 2012 at 11:25 am
This:
Steve Jones - SSC Editor (1/5/2012)
http://www.sqlservercentral.com/articles/books/76296/
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
January 5, 2012 at 10:50 am
No.
Unless you keep a record, there's no history of when an index was created or rebuilt.
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
January 5, 2012 at 10:50 am
ajsnyman (1/5/2012)
GRANTCONTROLSCHEMAdbo
That'll do the job... That's full control over the schema
Could it be an explicit grant (not a role)?
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
January 5, 2012 at 10:48 am
Viewing 15 posts - 21,301 through 21,315 (of 49,552 total)