Quick look and one major concern, only one production backup showing in the period of two weeks!

😎

Lowell (8/25/2014)

---

correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:

so C:\CambridgePubs.xlsx...

jkalmar 43328 (8/25/2014)

---

Hi. I have a table with columns KitID, BatteryID, TestID and LBSTAT. I need to exclude rows where LBSTAT='NOT DONE', but ONLY if there's not a row with...

N_Muller (8/25/2014)

---

I have a partitioned table and a partitioned index view on the table. As part of the clean up process, data from the partitioned table is switched out...

Just having a quick fun with this problem, this code probably has more of an entertainment value than being an actual solution (couldn't help it):-D

😎

USE tempdb;

GO

WITH cteText(string) AS (

...

shaimaa.tarekelshoeiby (8/25/2014)

---

Thank you ...

But with so limited time , what can I do to help me go through until I can have more time to read the book(s) you suggested...

shaimaa.tarekelshoeiby (8/25/2014)

---

Oh, an important question regarding the join

I learnt about using CTE instead of a view so that I can do it all as sql queries

However , adding the With...

vigneshkumart50 (8/25/2014)

---

Hi,

I have two columns like below

parsename('$'+ Convert(varchar,Convert(money,Q.[Profit Cost]-R.[Shared Dollars]),1),2) as [Pre Profit],

parsename('$'+ Convert(varchar,Convert(money,R.[New Cost+Shared Dollars]-R.[Shared Dollars]),1),2) as [Post Profit]

Formula to be applied:

When [Pre Profit]...

shaimaa.tarekelshoeiby (8/25/2014)

---

Thank you for the excellent post .

Can you please help me become capable of doing such analysis?

How were you able to make the simplified ERD and come up with...

Raghavendra Mudugal (8/25/2014)

---

I have one SP where...

Thank you for this nice piece C.J.

😎

Quick questions, did you create these...

Jeff Moden (8/24/2014)

---

You're saying that your normal data contains clear-text SSNs? And...

Quick question, how beefy is the index/indexes being rebuilt? Would it be an option to build an identical index with the ONLINE option and then drop the existing one afterwards?

😎

Just a quick thought, could this be a permission issue? Try creating a folder, give the appropriate permissions on...