Viewing 15 posts - 22,876 through 22,890 (of 49,552 total)
Ninja's_RGR'us (10/19/2011)
GilaMonster (10/19/2011)
Ninja's_RGR'us (10/19/2011)
Changed the case in the name of something.Dynamic/ad-hoc SQL only
When did that change?
Never. It's only ad-hoc SQL that's matched on a hash of the statement text. Objects...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 12:01 pm
Ninja's_RGR'us (10/19/2011)
Changed the case in the name of something.
Dynamic/ad-hoc SQL only
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 11:49 am
DMarvez (10/19/2011)
We'll pass along this suggestion and the warning that there may be unknown repercussions.
The only thing that disabling an account does is prevent people from logging in with it....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 11:46 am
sa can't be dropped. It can be disabled, which means no one can use it. I prefer that over renaming as there's an upgrade bug 2005-2008 if you have sa...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 11:24 am
Please open the SQL error log and find all errors relating to that database.
Got a backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 11:18 am
Ninja's_RGR'us (10/19/2011)
mbender (10/19/2011)
that stinks, but thanks for all you help very informative as usualIt's back online now. So hopefullly no more than 1-2 millions users got shut out ;-).
Maybe...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 10:46 am
Broker task is a system wait that should be ignored.
Async network IO typically means that the client app is being slow in consuming the resultset.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 10:39 am
It's the avg_page_space_used_in_percent column from sys.dm_db_index_physical_stats
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 9:51 am
Ninja's_RGR'us (10/19/2011)
No phone support?
Yes, I really want to sit on hold for an hour or 3 paying international phone charges. They have a toll-free number, but it's only toll-free if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 9:38 am
mbender (10/19/2011)
that link seems to be down
Yeah, my hosting company just suspended my site without warning and are taking their sweet time answering support tickets as to why and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2011 at 9:30 am
ravi@sql (10/18/2011)
example of code
declare @date datetime
set @date=getdate()
INSERT INTO CourseFeedback (Courseid,UserID,Feedbackxml,CreatedDate)
VALUES (@CourseId,@UserID,@Feedbackxml,@date)
The only way that can return anything other than the correct date is if the server's date is set wrong....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2011 at 11:55 pm
ravi@sql (10/18/2011)
And for yeterday for one insetion operation inserted date is '20011-11-11' .
You cannot in any way put 20011-11-11 into a datetime field. It'll fail with a conversion error.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2011 at 10:22 pm
Post the code.
Only way you can get a value like that is if you have dates stored as strings, which is not recommended.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2011 at 10:16 pm
Traffic takes time. I still had single-digit hits per day after 5 months. Write useful content, post links on questions where a post answers or helps. Consider tweeting new blog...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2011 at 7:18 pm
CXPacket waits mean that queries are running in parallel. That's all.
If you have high CXPacket waits for a query, the trick is to find what the one thread that doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2011 at 1:21 pm
Viewing 15 posts - 22,876 through 22,890 (of 49,552 total)