Viewing 15 posts - 1,636 through 1,650 (of 2,008 total)
Security Note: Always run SQL Server services by using the lowest possible user rights. Use a specific low-privilege user account or domain account instead of a shared account...
November 14, 2011 at 3:26 am
memymasta (11/14/2011)
Is there a way to login with NT AUTHORITY\SYSTEM account in sqlserver 2008 r2?
Why do you want to do that?
Local System Account
Local System is a very high-privileged built-in...
November 14, 2011 at 3:17 am
"can we try the same code...."
Yes we can, subject to:
•It’s the only query where we are doing it.
•It’s not a referential column.
It’s my observation on DB Designing practice, “If one...
November 14, 2011 at 2:32 am
AND (( = @key) OR (@key = ''))
I guess the line above will lead to Index Scan (or can skip the index).
AND (( = @key))
It should go for Index Seek.
I...
November 14, 2011 at 2:16 am
My ONLY argument is this.
Dev (11/11/2011)
ID
---
2|4|6
It's bad design. If you have control on database schema, re-design it.
November 14, 2011 at 2:08 am
After all the articles and conversations on this topic and you still have this oh so wrong.
What’s your point? What's wrong in the articles?
November 14, 2011 at 1:57 am
SQL Kiwi (11/13/2011)
Jeff Moden (11/12/2011)
Why, Dev? What's wrong with this solution? It works perfectly for what it was designed for.
I think he was encouraging the OP not to...
November 14, 2011 at 1:49 am
Recommended Reading: How to: Upgrade to SQL Server 2008 R2 (Setup)
November 14, 2011 at 1:42 am
I will try this on a VM.
Sure. Please don't forget to update us, if it works.
November 14, 2011 at 1:37 am
MysteryJimbo (11/13/2011)
This is ripped out of one my installation batch files.
C:\admin\SQL Silent...
November 14, 2011 at 1:34 am
Recommended Reading: Top Tips for SQL Server Clustering
http://technet.microsoft.com/en-us/magazine/2007.03.sqlclusters.aspx
November 14, 2011 at 1:10 am
The windows cluster group is not pinging.
Please focus on it. It’s IT Support’s job to make sure Server is up. We can start debugging for SQL Server thereafter.
November 14, 2011 at 1:03 am
Never mind. I found the setting to turn on deadlock graphs in sql profiler. Working perfectly now. If anyone else is having this problem, be sure to click the "show...
November 14, 2011 at 12:58 am
Is it better to configure the SQL Server with dynamic ports which - I think - leads to the activation of SQL Server Browser, or a static configuration?
The SQL Server...
November 14, 2011 at 12:50 am
First of all, read the Data Warehouse Toolkit by Ralph Kimball.Practically an industry-standard, and a must read for everyone who starts in data warehousing.
And not to forget Bill Inmon's Corporate...
November 14, 2011 at 12:05 am
Viewing 15 posts - 1,636 through 1,650 (of 2,008 total)