Viewing 15 posts - 6,496 through 6,510 (of 8,416 total)
Hey guys,
I got a fantastic response to the connect item I filed concerning the collation performance thing. Check it out at http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=512459
Extract:
Jim Hogg MSFT
December 5, 2009 at 1:30 am
Nitin.S.Pathak (12/1/2009)
we can not use table variable in the update table from @tablevariable
Alias the table variable.
Nitin.S.Pathak (12/1/2009)
We can use table variable inside functions but not the temporary tables.
Correct.
December 5, 2009 at 1:20 am
If the maximum value for quantity is relatively small, or if you don't have a Numbers Table available, something like the following provides an efficient alternative:
declare @data
table (
...
December 4, 2009 at 8:33 pm
C# Screw (11/29/2009)
Oh but if I switch current database from Master to 'Another' database I get very differerent results...
The collation thing again. It'd probably be fairer to tweak each...
November 29, 2009 at 5:41 pm
Erich Brinker (11/25/2009)
I posted here because we didn't really get a quality answer from Quest Support...
How shocking :laugh:
It would still be good to know that you are running the latest...
November 25, 2009 at 2:38 pm
1-2GB free is plenty on a dedicated box. Don't worry about it.
See http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx for more information.
November 25, 2009 at 2:37 pm
If your Windows Authentication account has the appropriate permissions, you can use any of the usual methods, including Management Studio and ALTER LOGIN
November 25, 2009 at 12:16 am
These questions might be better asked of the Quest LiteSpeed support team 😀
You might also try The Quest Online Support Forums.
Often, these things come about when using a older version...
November 25, 2009 at 12:11 am
Bob Hovious 24601 (11/24/2009)
2. numbers or tally table
3. thrice-damned cursor or elegant and efficient set-based solution
4. pork chop or steak
5. lightsabre, katana,...
November 24, 2009 at 7:46 pm
ManoharV (11/24/2009)
In our database there are around 3,000 procedures and as we are deploying our application in multiple location, we need some sort of encryption for...
November 24, 2009 at 2:38 pm
jcrawf02 (11/24/2009)
Paul White (11/23/2009)
My eyes!!!!!It's Paul's subtlety that has endeared him to millions.
:laugh: :laugh: :laugh:
November 24, 2009 at 2:09 pm
Michael Meierruth (11/24/2009)
The problem is replicate which will not return more than 8000 characters.
Books Online
November 24, 2009 at 2:07 pm
Michael Meierruth (11/24/2009)
November 24, 2009 at 1:50 pm
ManoharV (11/24/2009)
Is there any script or free tool to encrypt all the procedures in a database?
Well, there is the WITH ENCRYPTION option of ALTER PROCEDURE, but it's pretty weak.
It might...
November 24, 2009 at 2:18 am
Subhash-63067 (11/20/2009)
Hi All,What should be the ideal value for SQL Server: Memory Manager – Memory Grant Pending performance counter?
I have a server which showing >20 for this always.
The...
November 24, 2009 at 2:10 am
Viewing 15 posts - 6,496 through 6,510 (of 8,416 total)