Good points Steve and unfortunately far too common. A good Kensington Lock Kit costs around $20, interesting to see a raise of hands here, how many use those regularly?, and...

Revenant (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

TomThomson (4/13/2015)

---

Jeff Moden (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

djj (4/13/2015)

---

Revenant (4/13/2015)

---

Ed Wagner (4/13/2015)

---

whereisSQL? (4/13/2015)

---

Ed Wagner (4/13/2015)

---

eccentricDBA (4/13/2015)

---

Ed Wagner (4/13/2015)

---

Fun...

ramana3327 (4/13/2015)

---

Hi,

I am working in testing environment.

Some one deleted all data from all most all tables in a particular database. I want to find when that happened and which login...

ScottPletcher (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

ScottPletcher (4/13/2015)

---

Here's an alternative approach, also using CROSS APPLY, that can take advantage of the (presumed) clustered index on prefix.PREFIX_VALUE; no guarantee, but it might perform ...

jgale 70688 (4/13/2015)

---

Thank you for the replies.

Both solutions did work. However, the data I'm working with is slightly more complex than my simple example. My main data table is a...

Flag

ScottPletcher (4/13/2015)

---

Here's an alternative approach, also using CROSS APPLY, that can take advantage of the (presumed) clustered index on prefix.PREFIX_VALUE; no guarantee, but it might perform better.

SELECT p_cross_apply.PREFIX_VALUE, SUM(d.DATA_VALUE)...

Here is a little snip to play with

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_PARAGRAPH') IS NOT NULL DROP TABLE dbo.TBL_PARAGRAPH;

CREATE TABLE dbo.TBL_PARAGRAPH

(

PG_ID INT IDENTITY(1,1) ...

Lining

river1 (4/13/2015)

---

Hi,

I have a view named SGSCC

If I call it as select * from SGSCC it works fine

If I try to call it as select * from sgcc says that...

GilaMonster (4/13/2015)

---

Extended events or the sys.dm_db_session_space_usage DMV which tracks tempDB usage per session (not per table, just overall...

l'orange

cooljagadeesh (4/12/2015)

---

hi every,

can any one help on my issue

i have a input string

declare @string varchar(1000)='100010111100010001'

in string zero positions when it started and when it ended

output should be as...

PiMané (4/8/2015)

---

Hi,

I've a table with values that have the '-' char, ex:LO-AS-1.

I'm trying to search the table for that value but it returns more records since it breaks the search...

Quick question, why?

I agree with...