Steve Jones - SSC Editor (8/12/2016)

---

Lynn Pettis (8/11/2016)

---

Having rules for answering questions makes sense but I have to ask the question, Why? Has as been noted there are several...

shezi (8/11/2016)

---

The rounding works fine to two decimal places if I try to convert directly but when I put in a sub query then it doesn't do anything.

select CAST(391/60.00...

Sean Lange (8/11/2016)

---

Phil Parkin (8/11/2016)

---

Sean Lange (8/11/2016)

---

Ed Wagner (8/11/2016)

---

Steve Jones - SSC Editor (8/11/2016)

---

Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies,...

Steve Jones - SSC Editor (8/11/2016)

---

Ed Wagner (8/11/2016)

---

That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand...

chris.jess (8/11/2016)

---

This post by Kendra Little may or may not help to define what tasks to assign to your Junior DBA, I found it quite useful. Perhaps find out...

Brandie Tarvin (8/11/2016)

---

SQLRNNR (8/10/2016)

---

Brandie Tarvin (8/10/2016)

---

Sean Lange (8/10/2016)

---

Brandie Tarvin (8/10/2016)

---

SQLRNNR (8/9/2016)

---

Brandie Tarvin (8/9/2016)

---

Sigh.

I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without...

What's a Junior DBA? Sorry, I am the ONLY DBA in our company apparently even though I have seen advertisements for DBA positions at different sites in the US.

mw112009 (8/10/2016)

---

RE: The following code gives the error message :

Msg 156, Level 15, State 1, Line 6

Incorrect syntax near the keyword 'SCHEMA'.

-----------------------------------------------------------------

IF not exists ( Select * FROM SYS.SCHEMAS where...

You can use FindString in SSIS since you are looking for '.zip' in the string.

dallas13 (8/9/2016)

---

Thanks guys.

Patindex is not supoorted in ssis i guess. So if i use this in ssis then it may be prob. but i think i understand the logic here...

Y.B. (8/9/2016)

---

dallas13 (8/9/2016)

---

Hello I m trying to achieve something like this without patindex

DECLARE @source_path ...

Congrats.

Been working with MS SQL Server since 1996, no certs. Want to just to test my knowledge, just haven't made the time.

Solomon Rutzky (8/9/2016)

---

Lynn Pettis (8/9/2016)

---

Actually, we have identified 6453 plus a few more (actual count I don't remember at the moment). Basically, converting to a space for the lower...

curious_sqldba (8/9/2016)

---

Lynn Pettis (8/9/2016)

---

curious_sqldba (8/9/2016)

---

I am subscribed to these groups:

Current SubscriptionsNotification

Home » SQL Server 2008 » SQL Server 2008 Performance Tuning

Instant

Home » SQL Server 2014 » Administration - SQL Server...

dallas13 (8/9/2016)

---

Hello I m trying to achieve something like this without patindex

DECLARE @source_path ...