Viewing 15 posts - 3,181 through 3,195 (of 9,725 total)
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
So I fought and fought with this, ultimately going back to one of the sample scripts I was given. Here's where I ended up with (two read variables, one write...
May 2, 2014 at 11:48 am
Ditto to that.
Some days I just LURV SQL. If you know what I mean. @=)
May 2, 2014 at 10:51 am
Viewing 15 posts - 3,181 through 3,195 (of 9,725 total)