New Born DBA (2/3/2014)

---

I just implemented TDE on one of the DB in our Prod environment, will this cause any issue if I copy the Database from QA to Prod?...

If Jack is no longer able to take this one I would be willing to do it. What is the time frame on finishing it?

Please read the article in my signature on posting questions like this on the forum. Please provide the DDL statements along with the sample data inserts.

Are you sure that you didn't install 2005 by mistake? Seems like you are trying to open a 2008 mdf file in 2005. Run this command to verify your instance:...

For this case I would create a windows group that has data reader access and manage the group for who get's access. After that add that group to your db_datareader...

Try this:

SELECT X.PRODUCTNAME, X.PRICE, X.STARTDATE, X.MAXENDDATE, case when X.MaxEndDate = '9999-12-31 00:00:00.000' then 1 else 0 end as FlagActivePrice

FROM (

SELECT ProductName

, Price

, StartDate

, EndDate

, FlagActivePrice

, ROW_NUMBER() OVER (...

Can you supply the DDL for PersonType and Office?

I have been running some tests with profiler and set statistics time on and so far all of my Execution Times are reported as being the same as what profiler...

The issue comes down to not wanting to count weekends as days in your delete statement. I would recommend a date table that has a list of dates and has...

Here is something that works:CREATE TABLE #CustomerAccount

(

AccountNoINT,

Customer1IDINT,

Customer2IDINT,

Customer3IDINT,

Customer4IDINT,

AccountHoldersTinyInt

)

CREATE TABLE #AccountBalance

(

AccountNoINT,

Balance MONEY,

InterestMONEY

)

INSERT INTO #CustomerAccount(AccountNo, Customer1ID, Customer2ID, Customer3ID, Customer4ID, AccountHolders)

VALUES(10001,1,0,0,0,1), (20002,2,3,0,0,2), (30003,4,5,6,0,3), (40004, 7,8,9,10,4), (50005,11,12,0,0,2), (60006,13,14,15,0,3), (70007,16,17,18,19,4)

INSERT INTO #AccountBalance(AccountNo, Balance, Interest)

VALUES(10001,500,0.54), (20002,459,0.34), (30003,...

SQLRNNR (1/22/2014)

---

No, schedule regular backups and...

Just taking your normal tlog backups will clear the wait until there are new log records that need to be backed up, so seeing that description is pretty normal. Please...

What is the output of this code (change the database name):SELECT state_desc

FROM sys.databases

where name = 'DatabaseName'

I would stop shrinking the log file. If you want to keep the size of the file smaller take your tlog backups more often than once an hour. You are...

This means that it is waiting on a transaction log backup