Viewing 15 posts - 361 through 375 (of 1,132 total)
From BoL "Creates single-column statistics for all eligible columns for all user tables and internal tables in the current database."
The only situation where this should be considered is when all...
July 18, 2008 at 4:21 pm
Please read BoL topics "Implicit Conversions" and "Data Type Precedence" that define the rules, such that " N'a' + 'b' " is internally converted into " N'a' +...
July 18, 2008 at 4:09 pm
I do not have this procedure -
select db_name(database_id), * from sys.dm_io_virtual_file_stats(-1, -1)
For SQL server 2000, the function has a different name and different parameters.
CREATE TABLE dbo.DatabaseFileIO (
DatabaseName nvarchar (128)...
July 18, 2008 at 1:22 pm
The backup file may be corrupted such as by FTPing with char mode instead of binary and can be checked by running:
RESTORE VERIFYONLY
from disk = 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Hills.bak'
Your version...
July 17, 2008 at 11:31 am
Additionally, the SQL has "table_catalog = 'Rabbit'", but with SQL Server, the column "table_catalog" means the database name.
What needs to be included is the table_schema (dbo) but not...
July 16, 2008 at 1:31 pm
Try moving the DISTINCT keyword:
select bc.BowlingCenterID
, count(DISTINCT le.LeagueID) as LeagueCount
, count(tm.MemberID) as count
FROM ....
July 14, 2008 at 8:31 pm
Logical reads are 702,949, 129
How did you get 129 ?
The "129" did not come from anywhere but the confusion may be my use of "commas" to...
July 13, 2008 at 8:09 am
Do you mean that you want start a command file or program on one server that will run on a different server?
Windows does not include such a capability but there...
July 13, 2008 at 6:31 am
FYI: I have never had a problem with the newsletter size using Internet Explorer 6 with yahoo mail.
July 12, 2008 at 10:42 am
"logical reads" indicates the total number of rows read from all tables referenced and cannot be converted to any size value unless there is only one table being read.
"Reads"...
July 12, 2008 at 10:34 am
Add linked servers for each of the servers I want to query
The problem with linked servers is that if any of the SQL Servers are not accessable, this will cause...
July 12, 2008 at 5:15 am
[] are not supposed to change the meaning of a statement. They're supposed to just be delimiters.
But [] do change the meaning of SQL Statements.
In the below example, ...
July 12, 2008 at 5:07 am
The position of variable length made a difference about 15 years ago with version 6.0 but not with any of the current version.
July 11, 2008 at 5:18 pm
Although tables that begin with a # are normally temporary tables, it is possible to create a permanent table by enclosing the name with [ and ]
create table [#temp] (foo...
July 11, 2008 at 2:38 pm
From Gary L. Fry's post:
Make sure that the port is indeed available. If it is not and you assign the port number of a port that is used the...
July 11, 2008 at 2:57 am
Viewing 15 posts - 361 through 375 (of 1,132 total)