Viewing 15 posts - 18,166 through 18,180 (of 19,560 total)
You're welcome
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
January 13, 2010 at 11:46 pm
adam 19559 (1/13/2010)
In 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
January 13, 2010 at 11:46 pm
RedGate has a tool called Data Generator - that may be of help.
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
January 13, 2010 at 11:33 pm
I think you probably have the first one figured out.
For the second date format, try the following:
Declare @datestring nvarchar(100)
Set @Datestring = 'Wednesday, 13 January 2010 11:48:44pm'
Select CONVERT(datetime,right(@DateString,len(@DateString) - charindex(' ',@datestring)),112)
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
January 13, 2010 at 11:26 pm
I like your list - is it a Bucket List ;-)?
I find it interesting to see some of your items. Ironman is still one of my goals. I...
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
January 13, 2010 at 11:15 pm
What kind of domain accounts? Are they domain admin or user accounts? What local groups on the server are the user added to on this server?
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
January 13, 2010 at 11:01 pm
JWOL (1/12/2010)
1. Is it best to have one certificate per database, create a user from the certificate then grant that user whatever rights...
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
January 13, 2010 at 10:58 pm
Discretionary/optional would be what you deem best practices and necessary for your organization.
Mandatory controls are the types of practices required to pass audits and keep your network, data and organization...
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
January 13, 2010 at 10:55 pm
Jack Corbett (1/13/2010)
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
January 13, 2010 at 10:48 pm
info 68917 (1/13/2010)
what i would like to do is to simulate say, 2000 more records to make the total count 3000. i would like to fill in this 'dummy data'...
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
January 13, 2010 at 10:44 pm
Paul is giving away homework answers tonight.
http://www.sqlservercentral.com/Forums/Topic846696-338-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
January 13, 2010 at 10:38 pm
manoharanpraveen (1/13/2010)
Yes .you are right.I would keep the instance directory in C:\ Drive and use the 2 other drive assigned for data. am I right?
If it were me, I would...
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
January 13, 2010 at 9:07 pm
Nice editorial. And nice method of integrating it with your blog. Like I mentioned in your blog on it, I agree that there should be a certain level...
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
January 13, 2010 at 8:11 pm
david.wheelock (1/12/2010)
Further research revealed to me the (Right Click) > View History function. This revealed a permission...
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
January 13, 2010 at 8:04 pm
john.arnott (1/13/2010)
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
January 13, 2010 at 8:03 pm
Viewing 15 posts - 18,166 through 18,180 (of 19,560 total)