Viewing 15 posts - 151 through 165 (of 337 total)
Jeff Moden (6/19/2012)
Also, I'm sure it was a typo... a "scalar" UDF cannot return 160,000 rows. Perhaps you were talking about a multi-line table valued function.
Sorry it was a...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 21, 2012 at 10:19 pm
TheSQLGuru (6/19/2012)
We cannot tell you which of these is best for your environment. LOTS of things come into play such as memory usage, latching, locking, CPU use, etc. ...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 19, 2012 at 8:20 am
Thanks for the replies.
@Grant
Yes the whole optimization effort was done based on the readings of the execution plan.I have achieved significant gain in terms of the execution time(screenshot attached).
@opc.three
I did...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 19, 2012 at 8:08 am
Ideally you shouldn't be having a log backup job when you have log shipping doing it for you.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 12, 2012 at 1:45 am
Thanks.
There is absolutely nothing logged in there for that error.In fact before posting the issue on this forum I had thoroughly went through the installation steps multiple times to see...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
May 27, 2012 at 11:37 am
Wow I am also facing the same issue for SQL 2012 Rc0 installation.
http://www.sqlservercentral.com/Forums/Topic1304837-1549-1.aspx
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
May 26, 2012 at 1:55 am
No its not sharing any of the host resources.The version is 7.1.4 build 385536
Is there a possibility that this is happening due to corrupt installation media ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
May 23, 2012 at 1:16 pm
Its still running.
In the Task Manager "scenarioengine.exe" seems to be running and using the most memory.Not sure what that exe does.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
May 23, 2012 at 5:52 am
Also you can deny view definition to the user
Deny View Definition To [User]
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
May 17, 2012 at 12:39 am
Isnt it more suited for OLAP than OLTP applications cause I think it is more of a read only index.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 10, 2012 at 10:36 am
sp_change_users_login is going to be deprecated
http://msdn.microsoft.com/en-us/library/ms174378.aspx
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 21, 2012 at 3:14 am
GilaMonster (1/2/2012)
I assume, from the very low fragmentation and very high page usage that the indexes have been rebuilt since the delete at least once?
Yes we have this weekend job...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 2, 2012 at 9:23 pm
Ok the data was deleted about 2 weeks back and I think in these 2 weeks approximately 100000 records might have been added as data from this table is archived...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 2, 2012 at 8:00 am
Dev (1/2/2012)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 2, 2012 at 4:20 am
Yes it does looks surprising.
But the amazing thing is that the overall DB size and the back up size also is much larger.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 2, 2012 at 3:24 am
Viewing 15 posts - 151 through 165 (of 337 total)