How to recommend the correct clustered index --- for all tables.
This is a new one for me... SQL Server v2016 sp2. A customer says they have a script that needs to
…![SQL Server 2008]()
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.C...
Read more- 50K Content
- 7.1K Contributors
Expert Spotlight
SQL Server DBA & Architect, EE Solution Guide
I'm a SQL Server Architect experienced in Design, Development, Administration, Performance Tuning.. Exploring BI, SSIS & Data Science Arena!
Leading Experts In
Troubleshooting Solution
Article
Dynamic Pivot Procedure for SQL Server
by Mark Wills
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Video
Repair Corrupt SQL Database with Stellar Phoenix SQL Database Repair Software
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues…
Post
This is a basic sp but it returns a 1 properly but will not …
This is a basic sp but it returns a 1 properly but will not return anything when the statement is …
Article
Managing the Transaction Log for the Accidental DBA
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The …
Attending one of Rob Farley's seminars the other day, I heard the phrase "The …
Troubleshooting Solution
Sql query
Hello,
Any suggestions on how to write this query
Spec:
There are two columns …
Any suggestions on how to write this query
Spec:
There are two columns …
Troubleshooting Solution
Column calculations and inserting into table
Hello,
I have the following format:
Date,Signal,SystemIdent,De
There can be multiple …
I have the following format:
Date,Signal,SystemIdent,De
There can be multiple …
Troubleshooting Solution
SQL 2012 Intermittance
I have PHP web page that calls a stored procedure in SQL 2012 as UserA. The procedure does not …
Troubleshooting Solution
Query for null inner joins
I have table "cases" and table "Activities"
The tables join on cases.id = activities.caseid where…
The tables join on cases.id = activities.caseid where…
Troubleshooting Solution
Must optimize this procedure, need an assist
This is v2008 R2. A customer asked me to optimize a script. Typically not a problem, but I've …
Troubleshooting Solution
SQL Express 2005 upgrade to 2008 R2
I have a server that was using SQL EXPRESS 2005. I need to upgrade it to 2008 R2 to support our new…
Article
Fun with MS SQL spt_values for delimited strings and virtual calendars
By Mark Wills
Not so long ago, there was a fairly tricky question on Experts Exchange to do with …
Not so long ago, there was a fairly tricky question on Experts Exchange to do with …
Article
Encryption - Decryption in SQL Server 2008 and backup database with encrypted data and restore it somewhere else.
Long way back, we had to take help from third party tools in order to encrypt and decrypt data. …
Troubleshooting Solution
HELP!!! Cannot install SCOM 2012 R2 Reporting Server on my SQL server 2012 stand alone server
Hi, I am trying to finalize my SCOM 2012 R2 production install/setup, but when I go through the …
Troubleshooting Solution
Cannot launch SSRS Report Manager
SSRS v2012, I am the admin. I installed and configured SSRS in native mode successfully. I had …
Troubleshooting Solution
How to Make T-SQL Queries "Run Faster"
Hello:
Below is my code that is essentially a combination of two CTE queries, plus a separate …
Below is my code that is essentially a combination of two CTE queries, plus a separate …
Article
Managing Fragmentation for the Accidental DBA
By Mark Wills
We often hear about Fragmentation, and generally have an idea that it is about …
We often hear about Fragmentation, and generally have an idea that it is about …
Troubleshooting Solution
SQL Grouping Issue
Query
SELECT Clinum,superclient,Superke
…
SELECT Clinum,superclient,Superke
…
Article
SARGable functions in SQL Server
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, …
Troubleshooting Solution
VBscript SQL query hangs script
Hi,
I have a vbscript that querys a SQL database and put the records in to a text file. (CSV)
…
I have a vbscript that querys a SQL database and put the records in to a text file. (CSV)
…
Explore solutions and more
![SQL Server 2008]()
Microsoft SQL Server 2008Back to the top
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.