Viewing 15 posts - 3,931 through 3,945 (of 7,496 total)
Keep in mind, on clustered servers, it first upgrades the secondary node(s).
That may indeed take time !
Why aren't you applying SP3 +CU1 or higher ?
March 8, 2009 at 1:48 pm
did you test using row_number or ranking functions ?
That in combination with a CTE or temp table may help out on this kind of stuff.
Check books online or SSC...
March 7, 2009 at 8:43 am
Also keep in mind SQLServer 2005 / 2008 will only show info for objects you are granted to !
Meaning only if you have been granted (implicit or explicit) "view object...
March 6, 2009 at 6:35 am
If you can live with near-time solutions, don't go for realtime.
A trigger is executed in transactions scope, hence if your trigger fails, your whole transaction fails !
or:
-- the old way...
March 6, 2009 at 6:25 am
On the other hand ...
As the OP states
... If a database regularly creates, say, 50 Mb a day in transactions, but once a year I create 500 Mb of...
March 6, 2009 at 5:35 am
March 5, 2009 at 10:53 am
- must be a large open transaction.
does dbcc opentran show info (position in the correct database) ?
March 5, 2009 at 10:50 am
Thank you for the feedback.
March 5, 2009 at 12:38 am
I still miss the most obvious question ....
Does your data contain NULL and how does that relate to the results you expect from your queries?
FYI
http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/
http://www.sqlservercentral.com/articles/Advanced+Querying/2829/
http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/
http://www.sqlservercentral.com/articles/Miscellaneous/nullfunctionsarentthosemeetings/1313/
March 4, 2009 at 1:55 pm
- has your sproc been granted external access ?
- does the service account have delete authority on that unc pointed fileshare ?
You might as well use a vbscript in a...
March 4, 2009 at 1:49 pm
You cannot force an isolation level (except when you put a filegroup or db in read only mode).
Putting everything is serializable isolation level will raise the risk of lock timeouts...
March 4, 2009 at 1:41 pm
p.description,isnull(s.rankcode,9999) as rankcode,
...
order by S.rankcode, p.description, m.matnr
...
Removing the S. in s.rankcode made it work. I understand why. But i don't understand why it
I would suspect the collation...
March 4, 2009 at 1:35 pm
AShehzad (3/2/2009)
March 2, 2009 at 4:31 am
GilaMonster (3/2/2009)
ALZDBA (3/2/2009)
If there is more than one concurrent "#temp" object, sqlserver will add stuff to the object name to make it unique.
SQL will always add a prefix, whether it's...
March 2, 2009 at 4:09 am
Keep in mind tempdb is on of SQLserver's working horses !
If you ensist on quering the catalog for temp objects,
keep in mind SQLserver names them as it pleases.
If there is...
March 2, 2009 at 3:18 am
Viewing 15 posts - 3,931 through 3,945 (of 7,496 total)