infrastructure

External Article

The Database Administrator's Back-to-School Checklist

  • Article

To meet the upcoming demands on IT systems database administrators (DBAs) need to prepare the database and its supporting infrastructure for increased resource demands. Being proactive now can pay big dividends by maintaining service level agreements (SLAs), avoiding outages and resource shortages, and ensuring a positive overall customer experience.

2013-08-30

3,899 reads

External Article

Coping with Infrastructure Upgrades

  • Article

A common topic for questions on SQL Server forums is how to plan and implement upgrades to SQL Server. Moving from old to new hardware or moving from one version of SQL Server to another. There are other circumstances where upgrades of other systems affect SQL Server DBAs.

2012-12-17

2,026 reads

Technical Article

RE: Alert is not triggered

  • Reply

Is there a reason that you are using a severity level of 1. Severity levels less than 11 are for informational purposes and this may be causing some of the things that you are seeing. The 16 in your Raiserror is where the <state> goes. This <state> does not seem to do much. I hope this helpsEric 

2005-05-18

Technical Article

RE: Workflow question

  • Reply

Hi Steve,Can you looak athttp://www3.sympatico.ca/3005/support/dts1.htmlIs it what you mean? I'm a little confused about workflow part. Thanks, Robert

2004-10-13

Technical Article

How to Create Resume DB using SQL Server 2000

  • Topic

I'm new to SQLServer 2000 and would like to know if it is possible to createa database that would search,retreive and archieve resume?  Maybe it should not be done in SQL but in Ms Access I don't but I'd appreciate any feedback. Thanks in advance. 

2004-02-21

Technical Article

RE: Joins vs More Columns

  • Reply

I don't think it should be a speed issue, it's clearly a good design issue.  Creating multiple tables and a view over the top of that, makes the application more flexible.  Systems change all of the time, what happens when someone has three addresses or 5 phone numbers.  His 1 table design doesn't allow for […]

2004-01-14

Technical Article

RE: myLittleAdmin?

  • Reply

I had a quick look at the online demo version. It looks like a nice tool for some specific needs, for example when you need to move often from machine to machine and don't have the Enterprise Manager installed on all computers.

2003-06-17

1 reads

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

Can someone explain where non - clustered index is stored?

By yourjobismine

I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...

Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers