Viewing 15 posts - 136 through 150 (of 440 total)
Is Physical Address Extension (PAE) enabled?
March 2, 2012 at 10:06 am
I don't know if you can do this from Powershell. In a domain environoment, I would typically use GPO for this. For standalone servers, SecEdit may be an option.
March 2, 2012 at 7:03 am
Jeff Moden (3/2/2012)
Now that you've found out what the massive overhead is, can't you just bypass it and build a report of your own?
You mean create a web solution for...
March 2, 2012 at 6:51 am
I have now digged a bit more into it, and I fear that there is nothing we can do about this, although I sincerely hope that I am wrong. It...
March 2, 2012 at 5:22 am
Two ways of doing this:
Execute SQL Task to retrieve the SQL into a variable.
Another Execute SQL Tasks which executes the data in this variable
or
Excute SQL Task which store retrives the...
March 2, 2012 at 4:29 am
May I recommend Advanced Backup and Restore Options by Paul Randal?
March 2, 2012 at 4:17 am
Can you please elaborate? I Don't quite understand what you attempt to do.
March 2, 2012 at 2:15 am
I agree with those suggesting using a CTE, as I did in my old blog post: How do I remove duplicate tuples from a relation without any candidate keys?
Now, it...
March 2, 2012 at 12:17 am
SQL Server Client has support for Aliases, these may be published by using Group Policy Preferences.
March 1, 2012 at 11:42 am
John Mitchell-245523 (3/1/2012)
Security, to prevent attacks on the default port. Read about the SQL Slammer virus that hit nine years ago.
I tend to disagree. Yes slammer hit 1433, but...
March 1, 2012 at 7:05 am
Hi, just a little feedback. Under conclusion, you write:
If the SQL Server Browser service is not running, connection strings will have to specify the port number in order to connect.
As...
March 1, 2012 at 12:11 am
Btw, a common misconception. If you create aliases on your server, clients won't see them. Aliases are for the client library on the computer where the alias is defined only.
February 29, 2012 at 3:50 pm
Even in simple recovery model, you cannot guarantee that the log will be reused by having small transactions, as it depends on other factors as well. If you have other...
February 29, 2012 at 3:40 pm
left(field + replicate(' ',5),5)
February 29, 2012 at 3:28 pm
Viewing 15 posts - 136 through 150 (of 440 total)