Viewing 15 posts - 3,166 through 3,180 (of 9,712 total)
BTW...
mickyT (7/17/2014)
This query will not perform the best in 2008 as it will not use spatial indexes, however in 2012 it should use them. You will need to make...
July 23, 2014 at 6:20 am
What do the indexes on your tables look like?
July 23, 2014 at 6:19 am
sqlvogel (7/23/2014)
Brandie Tarvin (7/23/2014)
July 23, 2014 at 6:10 am
Grant Fritchey (7/23/2014)
Brandie Tarvin (7/23/2014)
July 23, 2014 at 5:40 am
Try this:
SELECT c1.*
FROM [CPACONTACTS].[dbo].[CPACONTACTS2] c1
INNER JOIN (SELECT COMPANY
FROM [CPACONTACTS].[dbo].[CPACONTACTS2]
...
July 23, 2014 at 5:38 am
Grant forgot to mention that you can't take transaction backups in Simple recovery mode. So verify your recovery mode first. If it's already in Simple (EDIT: given your original post...
July 23, 2014 at 5:34 am
There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the natural composite PK...
July 23, 2014 at 5:31 am
mattech06 (7/23/2014)
I have a table BankRef with a BankID column that was populated from the first 24 characters of a column TransDesc from another table BankTransactions.
I wish to repopulate the...
July 23, 2014 at 5:28 am
There are two ways you could do this. The first is using the MERGE keyword. I have not used MERGE, though, because it hasn't yet been useful to me. So...
July 23, 2014 at 5:22 am
How many of those data files are read-only files that could be moved to another disk to free up space for the read-write files?
How much of the data in...
July 23, 2014 at 4:45 am
Ah-HA!
While scripting the securables from the database role, I found this interesting piece of code that I don't see in BOL. This, apparently, is the syntax for adding a specific...
July 17, 2014 at 8:06 am
I think I've found a possible solution. I'm going to create a database role with these permissions in Production and then just assign the user group to that role in...
July 17, 2014 at 6:52 am
Methinks this post by broywin might be marketing spam since that tool has nothing to do with SQL Server.
July 17, 2014 at 5:05 am
So I found HttpWebRequest.Timeout and HttpWebRequest.ReadWriteTimeout. ReadWriteTimeout defaults at 300000, so I'm going to set it at twice that to see if it works (600000). I can't seem to find...
May 14, 2014 at 5:13 am
So this job has been running for a few weeks and for the first week I had to make changes to the package to account for scenarios I hadn't considered....
May 14, 2014 at 4:33 am
Viewing 15 posts - 3,166 through 3,180 (of 9,712 total)