Viewing 15 posts - 18,121 through 18,135 (of 19,560 total)
Database size, database use, database load, server hardware (cpu, disk space, and RAM) all play into the decision. Also, playing into the decision, is to what kind of Servers...
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 15, 2010 at 12:07 am
Chris Quinn-821458 (1/15/2010)
Chris Quinn-821458 (1/14/2010)
Chris Quinn-821458 (1/13/2010)
Chris Quinn-821458 (1/12/2010)
Chris Quinn-821458 (1/11/2010)
Chris Quinn-821458 (1/8/2010)
Chris Quinn-821458 (1/7/2010)
Chris Quinn-821458 (1/6/2010)
Chris Quinn-821458 (1/5/2010)
Chris Quinn-821458 (1/4/2010)
Chris Quinn-821458 (12/31/2009)
Chris Quinn-821458 (12/30/2009)
Chris Quinn-821458 (12/29/2009)
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 15, 2010 at 12:04 am
If you open a view in SSMS, no you cannot update from there. You would need to use insert and update statements.
What is that third party tool that allows...
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 14, 2010 at 10:18 pm
The lockout policy is controlled through the AD policy. If AD is not present, then it will use the Local machine policy. Try editing that policy - however...
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 14, 2010 at 7:53 pm
Bruce-12445 (1/14/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 14, 2010 at 7:50 pm
Thanks Paul.
Gail - can't wait to see that Blog post.
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 14, 2010 at 6:20 pm
This is awesome. This could keep me busy for quite some time. Amazing that you were able to do it so quickly. Nice article.
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 14, 2010 at 6:17 pm
saidwarak01 (1/14/2010)
Hi Jason,I got the answer for that
select convert(datetime,substring('10232016',1,2)+'/'+substring('10232016',3,2)+'/'+substring('10232016',5,4),101)
Thanks for your help.
sai
You're welcome.
When doing your actual conversions, make sure you replace that static date 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 14, 2010 at 4:51 pm
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 14, 2010 at 4:49 pm
Here is one alternative, to the best of my understanding (without data structures).
select t.refnbr
,sum(case
when t.doctype in ('IN','DM','SC','NS')
then t.origdocamt * 1 -- these doctypes are positives
when t.doctype in ('SB','CM')...
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 14, 2010 at 4:47 pm
Please provide table scripts. There are columns in your script (perpost,custid) no represented by your data or columns. Also, provide sample data that would enable this query 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
January 14, 2010 at 4:21 pm
This site should be useful for you.
http://www.sqlusa.com/bestpractices/datetimeconversion/
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 14, 2010 at 4:13 pm
We've done it the same way (jobs listed in database) and it worked fine. Not too terribly significant a load on the 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 14, 2010 at 3:09 pm
Lynn Pettis (1/14/2010)
SUGAR
And SPICE
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 14, 2010 at 2:37 pm
You can script out the table and its indexes from SSMS. As for the statistics, you should leave that to the DB Engine.
Once you script your table, change 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 14, 2010 at 2:30 pm
Viewing 15 posts - 18,121 through 18,135 (of 19,560 total)