Viewing 15 posts - 47,476 through 47,490 (of 49,552 total)
Please don't cross post. It's not necessary, the regular's read all the forums. It also fragments replies and wastes people's time.
Discussion to the following thread please - http://www.sqlservercentral.com/Forums/Topic451025-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2008 at 1:11 am
Please don't cross post. It's not necessary, the regular's read all the forums. It also fragments replies and wastes people's time.
Discussion to the following thread please - http://www.sqlservercentral.com/Forums/Topic451025-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2008 at 1:11 am
Sure it's possible. 2000 has to be installed first and can be the default or a named instance. SQL 2005 must be installed second and must be a named instance.
Make...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 3, 2008 at 11:08 pm
You should be able to create a calculated in the table, then put a unique index on that. It requires quite a few of the connection settings to have specific...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 3, 2008 at 11:50 am
Look at the definition of the file group.
Filegroups are logical collections of one or more files. If you look at the definition of the file group, it will say...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 3, 2008 at 7:06 am
CTEs are essentially temporary views, thus, no setting of vars or calling of procedures.
You can set and use variables in the statement that uses the CTE. -
;WITH Testing (ID)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 3, 2008 at 6:58 am
Standard edition? Enterprise edition? x86, x64 or IA64?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2008 at 8:42 am
What about the installation log file?
I can't remember offhand where it gets put, possibly in the dir with the SQL bin files
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2008 at 1:12 am
TheSQLGuru (2/1/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2008 at 1:09 am
What error did you get? Was there anything in the installation log file to suggest a cause?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2008 at 1:55 pm
Left join, to match all records and include the ones that don't have a match, then a filter to eliminate the rows that do have a match.
SELECT customerId
from customers...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2008 at 1:53 pm
Not from SQL. SQL Server only knows who the client machine is, in this case, the web server. If you need to be able to track back from there, you'll...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2008 at 1:46 pm
Books online is your friend...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2008 at 1:38 pm
Posting your homework once is bad enough. Posting it twice is pushing the limits. Posting it three times...
http://www.sqlservercentral.com/Forums/Topic450568-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2008 at 1:36 pm
The host name column will give you the machine name from which the query came. You can use the program name to identify the name of the app that submitted...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2008 at 1:27 pm
Viewing 15 posts - 47,476 through 47,490 (of 49,552 total)