sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a #temp_table. Any idea what could make it so...

As a datamart developer and data anayst, I often times work directly with end users, who are managers and department heads. Therefore, if I think of a bright idea, I'll...

I think more explanation is needed about what your script is demonstrating. Is your specific intent to demonstrate how to select from a "remote" stored procedure?

When I want to...

FDE isn't needed or required on the server, but definately for laptops belonging to corporate IT people. It's inevitable that sensitive information will end up in local email storage, Excel...

Times New Roman was commissioned by...

I'm a DBA on some development and QA servers but...

When you reference a table variable in a stored procedure, SQL Server operates on the assumption that it will contain at most a small number of rows, and will generally...

An alternate method to insure only one row (or 2, 3, ... rows) would be to simply define a unique key and check constraint on the table's ID column.

...

There is hardly ever a good reason for employees or contractors to copy sensitive production data down to the local SQL Server instance on their laptop or desktop. Any developer...

It seems like I hear more stories about sensitive data theft (or least misplacement) as a result of some developer's laptop getting stolen than I do about production database servers...

On any given day, I rarely check email while out of the office, even when not on vacation. If something important comes up, I'll get a call on my cell...

David Moutray (11/29/2011)

---

I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, the...

rashid_alavi (11/29/2011)

---

hi All,

I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, the...

Members of different teams often follow a rigid "start [this] only after [that] has been completed" development path that isn't necessary.

For example, when developing the data model and stored procedures...

rashid_alavi (11/27/2011)

---

Dear All,

i have column in my table which of datatype varchar(14) (20111107070115) , now i want to change display

2011/11/07 07:01:15 ( DD/MM/YYYY HH:MM:SS)

please help me on this ,...