Viewing 15 posts - 3,721 through 3,735 (of 19,560 total)
Try this
DECLARE @dollar TABLE (id INT IDENTITY(1,1),Cost INT)
INSERT INTO @dollar
( Cost )
VALUES (-4255),(25454),(467834)
select ID, GETDATE() as 'Date', REPLACE('$' + CONVERT(VARCHAR(20),CONVERT(MONEY,SUM(Cost))),'$-','-$') Dollars
,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 10:38 pm
http://support.microsoft.com/kb/2489376
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 10:29 pm
Grant Fritchey (2/12/2014)
GilaMonster (2/12/2014)
Benki Chendu (2/12/2014)
GilaMonster (2/12/2014)
Benki Chendu (2/12/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 7:58 pm
What have you built so far for you query to do that update?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 7:53 pm
That will work.
But why not apply those transaction log backups to the target as the backup occurs? You could logship those databases and keep them in sync and then...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 4:45 pm
parsnip
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 2:47 pm
I just read the rest of your problem title and had only gone off the description in your post.
Exporting reports as pdf to different folders is a different thing.
Sounds like...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 11:51 am
Try this series of articles (the link to the first article is in this article I am posting).
http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/
I show how to export both the data sources (part 2) and the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 11:20 am
Ed Wagner (2/12/2014)
Revenant (2/12/2014)
JAZZ Master (2/12/2014)
crookj (2/12/2014)
Daniel Bowlin (2/12/2014)
SQLRNNR (2/12/2014)
Ed Wagner (2/12/2014)
BWFC (2/12/2014)
whereisSQL? (2/11/2014)
SQLRNNR (2/11/2014)
Lynn Pettis (2/11/2014)
Seventh Heaven! (All this delicious food!!)Cloud 9
ecstacy
Agony
Pain
Gain
overtake
Surpass
Overpass
Bypass
Heart
surgery
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 10:09 am
Steve Jones - SSC Editor (2/12/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 9:18 am
GilaMonster (2/12/2014)
There's no procedural or application code that will stop someone from updating a table directly if they have permissions, or stop a newly written app from putting...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 9:14 am
GilaMonster (2/12/2014)
Eugene Elutin (2/12/2014)
...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 9:09 am
Are you building a dynamic sql string in your cursor and then executing that string?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 8:41 am
pmadhavapeddi22 (2/12/2014)
I am sorry if I have confused you.
I still stand on the same point that there are set of update statements in a stored procedure.Due to these updates, CPU...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 8:32 am
david.wright-948385 (2/12/2014)
sknox (2/12/2014)
WHERE
(
(a = b)
OR
(b = c)
)
AND
...
as opposed to
WHERE ((a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 12, 2014 at 8:02 am
Viewing 15 posts - 3,721 through 3,735 (of 19,560 total)