Viewing 15 posts - 19,546 through 19,560 (of 19,563 total)
This is accurate. If you login with 'sa', and then change the password - you must disconnect that session and login again with the new password
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
June 19, 2009 at 10:31 am
Torn page - I'm using Guerrilla Glue - better than duct tape or superglue - and has many more uses.
As for the coding questions. A DBA does have 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
June 19, 2009 at 10:27 am
With this being a highly busy OLTP configuration and drive C should be for system files - safest bet is Drive D for all files.
Better option would be to purchase...
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
June 18, 2009 at 6:16 pm
Which of the fields is the identity field? What are the datatypes for the remaining fields in your Key?
When comparing these queries, it is difficult to answer your question...
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
June 18, 2009 at 6:11 pm
Is TicketID an identity field?
What kind of data is in ActDtim?
Since the clustered key is the three columns combined, and if you have datetime as the data type in ActDtim,...
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
June 18, 2009 at 4:40 pm
Two bits
I like to throw in some good code and bad code samples. You pick out which one works better and tell me why. Or I will just...
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
June 18, 2009 at 4:13 pm
You can also run the full backup and split the BAK file in small chunks using winrar or similar tools. Then send each mini file via WAN to 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
June 18, 2009 at 3:30 pm
current version
with tablesize as (
select so.Name as TableName
,TableSizeMB = convert(decimal(15,2),si.dpages *8 / 1024)
,IndexSizeMB = convert(decimal(15,2),sum(isnull(si2.used,0))*8 / 1024)
,TotalSizeMB = convert(decimal(15,2),(si.dpages * 8 /1024) + (sum(isnull(si2.used,0))*8 / 1024))
,TableFreeMB = convert(decimal(15,2),(si.reserved * 8...
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
June 18, 2009 at 3:13 pm
Also keep in mind performance of Table Variables versus Temp Tables. Use the appropriate one for your need and size of data that will be used. Test first...
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
June 18, 2009 at 11:35 am
No. If you kill it, you will encounter the rollback.
I would recommend breaking up the job into smaller chunks so that it doesn't process as much at once, or...
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
June 18, 2009 at 9:15 am
Updated query, but still looking for the ability to find the allocation of each table to each file in the filegroup.
So far it is not looking too promising.
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
June 18, 2009 at 9:05 am
Thanks - that is the route we decided to take. Much more time consuming but is the best in the end.
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
June 11, 2009 at 9:05 am
I considered moving all tables already. In fact we are already in process of doing that. The only issue with it that I see is that it doesn't...
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
June 10, 2009 at 2:03 pm
This was pretty close to an automated solution.
In testing with a new puzzle not provided in the article, the first quadrant was all muddled up. The solution provided was...
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
June 9, 2009 at 1:53 pm
Pyramid schemes are illegal - and matrix, unilevel and binary trees could all be a pyramid scheme. The Fed monitors MLMs closely and makes sure they are in compliance...
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
December 31, 2008 at 8:02 am
Viewing 15 posts - 19,546 through 19,560 (of 19,563 total)