Viewing 15 posts - 18,151 through 18,165 (of 19,560 total)
Not being certain that I have the same FTI and catalog as yours, I was able to gain substantial improvement just by adding a Non-Clustered index to the currentdateout column....
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 9:27 am
Lynn Pettis (1/14/2010)
Steve Jones - Editor (1/14/2010)
Valerie Jones-467993 (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 9:14 am
Steve Jones - Editor (1/14/2010)
sjones-143898 (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 9:11 am
tina.muter (1/14/2010)
I tend not to post, I'm normally just a read, absorb and learn along the way. However I thought a round of applause was worth giving for...
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 9:08 am
Alvin Ramard (1/14/2010)
Steve Jones - Editor (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 9:05 am
mahesh.vsp (1/14/2010)
Am looking for answer for below two questions
1. How the logins got automatically mapped? How sid(s) got Mapped? Normally, we use auto_fix/update_one as parameters to sp_change_users_login.
2....
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 8:39 am
And in another it is evening.
Funny though
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:59 am
Shivrudra (1/14/2010)
please help on below
it is possible to create clustered index on col which does not have defined primary key ?
and
it is possible to create clustered index on col...
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 12:26 am
Thanks for the QOD. This was one where I was sure I knew the answer, but still needed to verify it online.
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 12:23 am
vindication
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 12:17 am
mahesh.vsp (1/12/2010)
Changing the database owner to sa solved the "dbo" user problemUSE database
EXEC sp_changedbowner 'sa'
GO
Do you still need answers to your questions from the original post, or did you resolve...
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 12:15 am
WilliamBendall (1/14/2010)
Your reporting requirements will determine how you configure your reporting database. Your question can't really be answered here as we don't have enough information on your requirements.
From 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
January 14, 2010 at 12:11 am
sqlbuddy123 (1/13/2010)
I have a created a SQL Server 2005 login with pw password1
Now I want reset the pw...
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 12:04 am
You would obviously need to make some modifications to make it work with your table. I left the variable in there just for testing purposes and demonstration purposes.
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 12:02 am
adam 19559 (1/13/2010)
Hello again!Yes both formats are stored in the same column (ugh...) and they both need to change. It's horribly frustrating...
table name: KPCourseDetails
column: lessondate
This will probably work (so long...
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 12:01 am
Viewing 15 posts - 18,151 through 18,165 (of 19,560 total)