If you go through Object Explorer use the Script Button to see what would be run if you clicked OK. To be safe I would recommend just running the ALTER...

In my experience, and know that if you ask 10 people it's possible to get 10 different answers, a "Production DBA" does environment support and is usually on-call 24/7 for...

USE [master]

GO

EXEC xp_instance_regwrite

N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer',

N'DefaultData',

REG_SZ,

N'C:\ new data file path...'

GO

EXEC xp_instance_regwrite

...

cms9651 (5/15/2013)

---

hi there, hope in your help.

I tried this code in sql server, but I've this error.

Can you help me?

I would really appreciate any help.

sp_configure 'Allow Updates',

0;

RECONFIGURE WITH override;

EXEC...

That's always a tough assignment. Can you interact with the live database? If so, start inspecting the queries in the plan cache to see how data clients are interacting with...

What kind of alert? That the OS is low on memory? How low?

You have max memory set but that only pertains to the buffer pool. Did you check to see...

Elated 😛

Look into your split of read to writes by database. Check performance counters over time to see where your bottleneck is, all systems are constrained by something. Look at your...

There are many types of DBAs. System, Development/Application, Production Support, to name a few. The responsibilities of each type actually vary widely, and within each type they can change based...

Apples and Oranges. LINQ is an application programming technology that allows us to abstract the querying of "things" in a generic way. SQL is for interacting with data in relational...

Unfortunately not. From Features Supported by the Editions of SQL Server 2012:

tempdb is a special database when it comes to redefning the initial size. Unlike other databases you can actually ALTER the files to be smaller than their current size without...

There is not nearly enough information to say definitively what you should buy. It will depend on the data access patterns you have in your environment, the number of transactions...

reported as link spam

Tickets? As in "what will you be asked to do when you take a job as a DBA?" Are you considering interviewing for a DBA job or are you already...