Viewing 15 posts - 511 through 525 (of 3,738 total)
Jayanth_Kurup (8/2/2015)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 3, 2015 at 6:18 am
I wish that I could get some example code to perform this.
I'm Swamped at the moment.
Thanks.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 2, 2015 at 3:00 pm
Jeff,
That was I thought. Thank you for responding and have a great day.
We do transaction log backups every 5 minutes and I had this new women zap a table on...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 2, 2015 at 2:37 pm
homebrew01 (9/9/2011)
it might help if you could explain your goals. What is the current environment ? What do the users...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 2, 2015 at 10:31 am
J Livingston SQL (8/2/2015)
Welsh ...your ideas from a few years back...maybe jog your memory 🙂
Yeah really I'm shooting blanks when it comes to recall what I did.:blush:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 2, 2015 at 10:02 am
Jayanth_Kurup (8/2/2015)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 2, 2015 at 9:59 am
I would prefer not to go with partitioning.
About ten years ago I created at table that captured the start and end date. The number of records Committed etc.
I wrote code...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 2, 2015 at 9:37 am
Does anyone have a script to archive data?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2015 at 4:58 pm
J Livingston SQL (8/1/2015)
is this the book you are referring to?http://www.sqlservercentral.com/articles/books/89519/
free download
Yes Sir.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2015 at 4:56 pm
Hi Lynn,
A Business Analyst gave me a requirement to create a new table when in fact there already is one.
I commented the sub query replaced it with a CASE Statement.
This...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 30, 2015 at 2:22 pm
How do I filter the sub query to return one record from my Credit Lookup Table?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 29, 2015 at 4:17 pm
I found out that I need to get the ID not the Description and as a subquery must JOIN with this code:
create table #tmpContractorCreditReports
(
AutoID int identity (1,1),
Contr_ID int,
CRRPT_ID_NB int,
CRRPT_RUN_DT datetime,
reporttype...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 29, 2015 at 3:32 pm
Thank you! 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 29, 2015 at 2:37 pm
Basically what I'm trying to do is to populate the ActionRating Column in the #ImportExperianDataTest Table based on the Min_Score Column in the ActionRatingDuns Table.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 29, 2015 at 2:26 pm
I need to return as part of the SELECT Statement the Experian Score that is derived by comparing the score in the #ImportExperianDataTest Table it to a range in...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 29, 2015 at 1:42 pm
Viewing 15 posts - 511 through 525 (of 3,738 total)