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...

Selecting a tool before fully understanding the problem is not very clever!

😎

Quick questions,...

Quick solution utilizing a recursive CTE, fine for small sets but I suggest you have a look at Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] and...

makis_best (4/12/2015)

---

Hi

I have a table with records like that.

Group | Value

Team 1 | 0

Team 1 | 0

Team 1 | 1

Team 1 | 1

Team 2 | 0

Team 2 |...

The row size is roughly the...

rajemessage 14195 (4/12/2015)

---

hi,

I am making one big table which will have good no of cols,

There is one critaria that is, to seepd up keep the lengh of row less than...

rajemessage 14195 (4/11/2015)

---

hi,

"So, what does that mean for index columns order? Quite simply, if queries are always going to filter with one or more equality predicates and one or...

Further on pietlinden's...