Viewing 15 posts - 12,706 through 12,720 (of 19,560 total)
I too am grateful for the community. I think the community is great.
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
August 30, 2010 at 8:53 am
Ray K (8/30/2010)
Three!!!(Days 'til I leave for vacation!)
Three days hahahaha (The Count from Sesame Street)
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
August 30, 2010 at 8:50 am
Brandie Tarvin (8/30/2010)
CirquedeSQLeil (8/28/2010)
I'll never think of "comma delimited" in the same way againForum Post title:
To split comma delimiterd string
Has somebody been leaving hamster poo in here?:hehe:
BWAHAHAHA.
Jason, I'm going to...
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
August 30, 2010 at 8:49 am
Triplicate post
Respond here:
http://www.sqlservercentral.com/Forums/Topic977038-1633-1.aspx
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
August 28, 2010 at 9:13 pm
Duplicate post
Respond here:
http://www.sqlservercentral.com/Forums/Topic977038-1633-1.aspx
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
August 28, 2010 at 9:12 pm
Lowell has explained it quite nicely. A recommendation would be to simply specify the email address of the group rather than the display name of the group.
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
August 28, 2010 at 4:54 pm
Alvin Ramard (8/28/2010)
Jeff Moden (8/28/2010)
Alvin Ramard (8/27/2010)
How many times must I repeat this? We do not need a DBA!!!!http://www.sqlservercentral.com/Forums/Topic976708-266-1.aspx#bm976772
Looks like someone's about to have a great weekend.
Let's hum them...
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
August 28, 2010 at 1:49 pm
For any interested - this site may be of use.
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
August 28, 2010 at 1:09 pm
Jeff Moden (8/28/2010)
Gopinath Srirangan (8/28/2010)
I am creating a table of row size char(1000) as below.
create table Optimised(id char(1000))
i am insert values 1,2,3,4.....
insert into Optimised values('1')
insert into Optimised values('2')
insert into Optimised...
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
August 28, 2010 at 11:21 am
This article may be of interest. There is more overhead imposed by the internals of SQL server than what you listed.
http://www.sqlservercentral.com/articles/Miscellaneous/pagesize/497/
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
August 28, 2010 at 11:17 am
I forgot to mention one last one. Here is a post I wrote on what I used for this.
http://jasonbrimhall.info/2010/03/19/security-audit/
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
August 28, 2010 at 9:26 am
Try the scripts from this article:
http://www.mssqltips.com/tip.asp?tip=2048
or this one
http://www.mssqltips.com/tip.asp?tip=1881&home
or this one (output into html)
http://www.mssqltips.com/tip.asp?tip=1818
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
August 28, 2010 at 9:23 am
I'll never think of "comma delimited" in the same way again
Forum Post title:
To split comma delimiterd string
Has somebody been leaving hamster poo in here?:hehe:
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
August 28, 2010 at 9:15 am
Each Page has overhead as george said. Due to the overhead, you would be creating a new page on the 8th insert.
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
August 28, 2010 at 8:47 am
tylenol
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
August 28, 2010 at 8:44 am
Viewing 15 posts - 12,706 through 12,720 (of 19,560 total)