pkapas (1/22/2015)

---

I have a stored procedure that calls several views that rely on each other. In the past these views used to go parallel and use up all 100% of...

Brandie Tarvin (1/21/2015)

---

HeaddeskHeaddeskHeaddesk.

Can I scream yet?

I just got the "white paper" for a new project. 46 freaking pages of "time to integrate the systems". Which isn't bad. I support the...

That's probably the best way around the problem, schedule the job for off-hours/maintenance window execution when no users are affected.

😎

denis.gendera (1/21/2015)

---

I have table with PatchGroup Information. I like to run query using While statement that returns specific results for each patch group.

I'm using SQL Function and doing the...

Quick thought, one can query the xml for both element/attribute names and values, if you have some sample XML then I'll chip in a query for this.

😎

Thordog (1/21/2015)

---

ALTER TABLE [dbo].[TableNameExample] REBUILD PARTITION = ALL

WITH (DATA_COMPRESSION = PAGE)

The table is 110 GB, so will take time to compress. But it is one table in a database...

Stephanie Giovannini (1/21/2015)

---

I'm attempting to convert some INSERT-EXEC structures into table-valued functions because the procedures are deeply nested and INSERT-EXEC doesn't like nesting (Error 3915: Cannot use the ROLLBACK statement...

Post the...

Here...

GilaMonster (1/21/2015)

---

Bulk Inserts don't fire triggers. Nothing to do with the trigger code (which, from the looks of things needs a lot of work to optimise it). The Bulk Insert...

Sioban Krzywicki (1/21/2015)

---

Hi everyone,

I have a bit of an announcement and a question.

I'm Transgender. I've come out as a woman in nearly every aspect of my life now and am...

No worries, glad to help.

One of my favourites...

Quick suggestion, use FOR XML PATH to concatenate the output into one dynamic sql string

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE [dbo].[Control_Table](

[Server_Name] [varchar](50) NOT NULL,

[Database_Name]...

I've been working on performance tuning and optimization of few special purpose functions which where derived from the DelimitedSplit8K function, wanted to share some of the findings related to the...

This is possibly an overkill but can easily be extended

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

THREE_PART_NUM VARCHAR(50) NOT NULL PRIMARY KEY CLUSTERED

);

INSERT INTO @SAMPLE_DATA (THREE_PART_NUM)

VALUES

...