Viewing 15 posts - 241 through 255 (of 687 total)
Markus (4/23/2012)
Did anyone see that there was a perfect game thrown against the Mariners in Seattle? The 21st perfect game.
Yeah, that was great! Always good to see someone get...
April 23, 2012 at 6:56 am
Here's a substring solution to go with Kingston's DDL. Not sure which is faster.
select
SUBSTRING(filename,len(filename) - charindex('\',reverse(filename),1) + 2,charindex('\',reverse(filename),1))
from @files
April 19, 2012 at 6:42 am
That's a pretty slick solution. Using this snippet is pretty neat to get random values per section. ROW_NUMBER() OVER( PARTITION BY [field] ORDER BY CHECKSUM(NEWID()) )
April 19, 2012 at 6:12 am
SQL Server doesn't have any load balancing solutions.
High Availability != Load Balancing
April 17, 2012 at 5:43 am
Just throwing out ideas here.
Is the U: drive a mapped drive or a local drive?
Have there been group policies enforced recently?
Are you using mount points in any places?
And lastly, as...
April 10, 2012 at 11:39 am
Yeah, wooo baseball!
I was fortunate enough to get to the final exhibition game when the Red Sox came to town! Great game, lots of fun to watch the boys...
April 9, 2012 at 1:29 pm
Laura_SqlNovice (4/9/2012)
--Now restore using the backup (if only needed)CREATE CERTIFICATE TEST_CERTIFICATE
FROM FILE = 'D:\Encryption\TEST_CERTIFICATE_BACKUP.cer'
WITH PRIVATE KEY
(
FILE=N'D:\Encryption\TEST_CERTIFICATE_ALT.pvk',
ENCRYPTION BY PASSWORD = N'ABC123'
)
[/code]
"DECRYPTION BY PASSWORD" is the correct syntax
April 9, 2012 at 1:24 pm
SQLRNNR has a good summary[/url] of study topics for the 70-450 exam. They are all online and available free.
April 9, 2012 at 6:33 am
If you want to see the duplicate records in the table, you don't need that subselect in the where clause.
SELECT
count ([Key])
,[SLA]
,[PCCode]
,[PrCode]
,[LocalID]
,[DateOfBirth]
,[Number]
,[ATariff]
,[DSeen]
,[MPI]
,[Service]
,[POD]
,[Device]
,[ActivityDate]
,[SeenDate]
,[DateActivity]
,[Period]
FROM [PROV].[dbo].[DA]
GROUP BY
[SLA]
,[PCCode]
,[PrCode]
,[LocalID]
,[DateOfBirth]
,[Number]
,[ATariff]
,[DSeen]
,[MPI]
,[Service]
,[POD]
,[Device]
,[ActivityDate]
,[SeenDate]
,[DateActivity]
,[Period]
HAVING COUNT () > 1
Edit: Phil...
April 6, 2012 at 5:54 am
yay for baseball! Again, I've been soaking up all the spring training games I can!
Opening day in Japan... I get it, as Markus said, international play = $$ for MLB....
March 28, 2012 at 11:09 am
Alright, been working on this and it has been troubling me this morning. My solution probably isn't ideal but I believe it to be close to what you want.
Before I...
March 26, 2012 at 9:15 am
Restricting growth of a file is not the same as data fill. As Ms. Shaw asked, are you experiencing bottlenecks with IO on a particular disk?
March 26, 2012 at 7:18 am
You cannot deny or revoke permissions to special roles. Db_datareader happens to be a special role.
You can make a workaround by creating a new database role <Role1> and adding this...
March 26, 2012 at 7:14 am
Viewing 15 posts - 241 through 255 (of 687 total)