My online follow up session for Hyderabad Techies covered SQL Server index maintenance: detect, create and rebuild. Over 50 people joined and asked questions.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT
INSERT TOP (N) INTO a table is not the same as INSERT with SELECT TOP (N). My example from a client training shows how the two methods differ.
QUOTENAME Object Names: Quote Each SQL Server Name Part
QUOTENAME object names separately to keep each part of a qualified SQL Server name intact. The function surrounds its entire input with identifier delimiters. A dot inside that input stays inside one quoted name. I keep the schema and object in separate variables.
SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review
I presented a session on SQL Server indexes at Microsoft User Group Hyderabad, led by Hima Vindu Vejella. The index talk was very well received.
SQL SERVER – Introduction to Rollup Clause
An introduction to the Rollup Clause in SQL Server, which aggregates at several levels of a hierarchy. A population table by country, state and city shows how.
Data Mining Algorithms (Analysis Services – Data Mining)
I quite often receive requests for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here.
geometry STOverlaps: Intersection Alone Is Not Enough
geometry STOverlaps asks a narrower question than whether two shapes share any points. I test equal and contained regions alongside a partial overlap. Those intersecting cases do not all satisfy the method’s overlap definition.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.