Viewing 15 posts - 3,436 through 3,450 (of 19,560 total)
I have frequently seen Commvault to be the source of backups as you describe them.
You might want to check with the sysadmins to see if anybody has a tool such...
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
March 5, 2014 at 7:11 am
Steve Jones - SSC Editor (3/5/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
March 5, 2014 at 6:14 am
Gary Varga (3/5/2014)
That's unusual as there often is a charge: maintenance contracts 😉
+1
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
March 5, 2014 at 6:11 am
dwain.c (3/4/2014)
SQLRNNR (3/4/2014)
Sorry about that link. It was at the top (of the article) and probably could have been more visible.
Pardon my aging eyes. The link is there...
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
March 4, 2014 at 8:36 pm
dwain.c (3/4/2014)
One question. In the section where you're describing left-deep/right-deep, is it safe to assume you're saying that the context only...
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
March 4, 2014 at 7:49 pm
Grant Fritchey (3/4/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
March 4, 2014 at 2:26 pm
EL Jerry (3/4/2014)
Revenant (3/4/2014)
Ed Wagner (3/4/2014)
crookj (3/4/2014)
SQLRNNR (3/4/2014)
microbotBug
Bacteria
Virus
Disease
cure
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
March 4, 2014 at 2:19 pm
Lowell (3/4/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
March 4, 2014 at 2:19 pm
Keith Tate (3/4/2014)
dbcc freeproccache.It is...
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
March 4, 2014 at 1:35 pm
Is it a file stored by a client or is he perchance looking at ssis or ssrs binary stored in the database?
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
March 4, 2014 at 1:33 pm
Cost can help you determine if the query has been tuned.
In addition, you could use statistics time and statistics IO.
Examining the execution plan can really help to determine if 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
March 4, 2014 at 1:31 pm
That query would work well.
I have seldom seen this kind of requirement. When I have, it is something we throw in the presentation layer. A common place for...
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
March 4, 2014 at 12:42 pm
Here is a possible option
USE tempdb;
GO
DECLARE @reccount INT = 0
CREATE TABLE #sometab (someid INT IDENTITY(1,1),someval VARCHAR(500),Category VARCHAR(20))
INSERT INTO #sometab (someval,Category)
VALUES (
...
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
March 4, 2014 at 11:10 am
The Dixie Flatline (3/4/2014)
Masterful? Do you need to borrow money or something, Jason?
Well, since you asked...:-D
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
March 4, 2014 at 10:42 am
Thanks Troy. Much appreciated.
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
March 4, 2014 at 9:14 am
Viewing 15 posts - 3,436 through 3,450 (of 19,560 total)