Viewing 15 posts - 5,386 through 5,400 (of 7,168 total)
Not a problem Jeff. Here is how I got there:
Build a Tally table to facilitate building of MyList with 400K rows:
USE tempdb
GO
-----------------------------------------------------------------
-- Build Tally table.
-- Script credit: http://www.sqlservercentral.com/scripts/Advanced+SQL/62486/
IF EXISTS...
July 23, 2011 at 3:09 pm
I would try the identity column method you mentioned...but use a table variable instead of a traditional temp table. I did some quick testing and inserting 400,000 rows into the...
July 22, 2011 at 10:12 pm
Ahh...you posted in a SQL 2008 forum and I completely breezed by the first line of your post and went straight to your sample data and the later statements in...
July 22, 2011 at 9:57 pm
Jason provided a good lead mentioning Ownership Chaining. Cross-database calls will break an Ownership Chain unless a non-default configuration is put into place. Are these cross-database calls?
Chains can be...
July 22, 2011 at 7:13 pm
Disclaimer: I do not have your tables on my side so this is untested code.
If this code does not work for you right off the bat then hopefully it will...
July 22, 2011 at 6:51 pm
SELECT customerID,
fullname,
phone,
ROW_NUMBER() OVER ( ORDER...
July 22, 2011 at 6:35 pm
This PowerShell snippet could be easily modified to start with a list of server names and provide a list of named instances you can then move forward with checking:
July 22, 2011 at 6:33 pm
allamiro (7/20/2011)
What if I want to change the size limits of the file to 50 MB for example is it also a default can not be changed ?
I do not...
July 22, 2011 at 4:20 pm
NBD4K27 (9/6/2007)
That was what I originally thought; however,I saw one of our servers had some trace files in the defualt location and thenInoticed one trace file in a different location...
July 22, 2011 at 4:12 pm
A good rule of thumb is to only grant user access to objects via Database Roles. It makes security management and auditing simpler in the long run and is not...
July 22, 2011 at 11:41 am
Jeff Moden (7/22/2011)
ALZDBA (7/22/2011)[hrOf course there is nothing wrong with yea good old DOS ..... in a sqlagent job please.
Not in the in-transaction-code !
I have to disagree there. ...
July 22, 2011 at 7:16 am
ALZDBA (7/22/2011)
You know I'm on my powershell learning curve, so that's what came out of my sleeves :hehe:
Granted, the OP could get the job done with CmdShell using COPY instead...
July 22, 2011 at 6:58 am
Oracle_91 (7/22/2011)
do we have the event notifications for sql 2008 apart from CDC(change data capture)?
Yes. Event Notifications are there...but as Eddie pointed they do not cover DML events.
July 22, 2011 at 6:38 am
Viewing 15 posts - 5,386 through 5,400 (of 7,168 total)