Viewing 15 posts - 151 through 165 (of 687 total)
Here's what I did to resolve the issue.
I set to single_user with rollback immediate which didn't resolve the issue. I couldn't switch back to multi_user because the system id was...
June 10, 2013 at 2:44 pm
It is interesting that when I run a backup command, the wait types switch.
So normally spid 16 has the pagelatch_up and the wait resource is 1:2872334.
When I run a...
June 10, 2013 at 1:28 pm
This is on 2008 R2 SP2. I know there's a KB addressing a similar bug for 2008.
June 10, 2013 at 12:08 pm
Grats on the interview and I hope it goes well for you.
I can't say I've ever interviewed for a SSRS job but I would think the usual interview policies would...
June 7, 2013 at 8:10 am
SSRS cache can be a curse and a blessing. It normally affects development as your making many changes quickly and end up being a victim of the cache's old data.
The...
June 3, 2013 at 6:30 am
Without additional auditing there is no default way to detect the reason for log growth.
May 31, 2013 at 6:49 am
TDE works seamlessly and ... transparently in the database. No encryption/decryption needs to happen at the application level.
May 29, 2013 at 7:06 am
Depending on your environment schemas can be used a couple different ways. They can logically group types of tables together like
lookup.state
lookup.country
lookup.zip
admin.role
admin.permission
admin.rolePermission
person.name
person.address
dbo.appTable1
dbo.appTable2
...
Schemas can also provide additional security functionality for a database....
May 28, 2013 at 11:47 am
I had tried IP addresses in the scripts and it also returns a null systemName. I even tried creating a DNS alias for the long server name and it still...
May 28, 2013 at 7:20 am
Alright. I did some more testing and I figured it out!
The computer naming convention we have is 15 characters in length which is apparently too long for powerShell.
I created a...
May 28, 2013 at 6:25 am
Great suggestions, unfortunately it was still an unsuccessful attempt. I tried hyphenated, en-dash, and em-dash, all of which returned the same results, yet still no systemName. I went so far...
May 23, 2013 at 6:37 am
Nats/Tigers game last night. Pretty much the same atmosphere. Started out raining then slowed down to a misty drizzle. Game was delayed an hour but I got to see Mr....
May 9, 2013 at 8:24 am
Viewing 15 posts - 151 through 165 (of 687 total)