Viewing 15 posts - 916 through 930 (of 1,131 total)
"But a file is not necessarily all contiguous. What if an IAM has extents from different areas of the file that are not physically contiguous"
Instead of "different areas of the...
SQL = Scarcely Qualifies as a Language
November 5, 2005 at 4:30 pm
Each object has at least one IAM for each file on which it has extents.
An IAM page is 8K bytes which is 65536 bits ( 8 * 1024 bytes *...
SQL = Scarcely Qualifies as a Language
November 5, 2005 at 4:14 pm
It is not clear from your post what you are attempting to do.
Some alternatives:
1. Populate a table on ServerA from the result of a SQL statement run versus ServerB.
2....
SQL = Scarcely Qualifies as a Language
November 5, 2005 at 6:33 am
Did you change the SQL Server and SQL Agent Account using the Services Manager? If so, you will encounter a lot of problems.
Change the accounts using Enterprise Manager, restart...
SQL = Scarcely Qualifies as a Language
November 5, 2005 at 6:24 am
See
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=235185
SQL = Scarcely Qualifies as a Language
November 4, 2005 at 4:05 pm
Regarding performance
Look in the system event log for any hardware failure events.
Next, use performance monitor and look at these counters:
Network - Bandwidth vs bytes/sec - bandwidth should be much...
SQL = Scarcely Qualifies as a Language
November 4, 2005 at 4:02 pm
Please be aware that neither IF UPDATE() nor COLUMNS_UPDATED() will indicate if the column value has changed, only that column is "set" in the update statement.
SQL = Scarcely Qualifies as a Language
November 4, 2005 at 6:39 am
See http://support.microsoft.com/lifecycle/?p1=2862
Extended support will end in 2010.
Mainstream support will end on 12/31/2005 (less than two months!).
WARNING - from the MS site:
Hotfix support that is not security-related requires a separate extended...
SQL = Scarcely Qualifies as a Language
November 4, 2005 at 6:39 am
I absolutly agree with "GilaMonster".
Having a column with parts violates the principles of relational databases and will cause a significant number of bugs. For example: There was...
SQL = Scarcely Qualifies as a Language
November 4, 2005 at 6:17 am
It is in BOL: in the index, enter transactional replication and then select planning. About halfway down in the page will be:
Primary Keys
All published tables in transactional replication must...
SQL = Scarcely Qualifies as a Language
November 4, 2005 at 5:22 am
For reference on the trace events and trace columns, see in BOL sp_trace_setevent.
As sqlmaint.exe is a program, not a SQL statement, so "sqlmaint" might be in the "ApplicationName" field but...
SQL = Scarcely Qualifies as a Language
November 4, 2005 at 5:17 am
One can get sqlmaint.exe or xp_sqlmaint to write to the maintenance history table by including "-WriteHistory" as an argument. When no maintenance plan is specified, the results appear under...
SQL = Scarcely Qualifies as a Language
November 3, 2005 at 4:08 pm
P.S.
The example uses the Northwind database
SQL = Scarcely Qualifies as a Language
November 3, 2005 at 3:58 pm
Think of an indexed view as an table where SQL Server automatically syncronizes any updates made to the underlying tables.
Maybe
If you are running either Enterprise or Developer Edition
- or...
SQL = Scarcely Qualifies as a Language
November 3, 2005 at 3:57 pm
Yes and No: DBCC can only be run by logins with the system adminstrator role.
Can sp_spaceused be used instead ?
SQL = Scarcely Qualifies as a Language
November 3, 2005 at 3:28 pm
Viewing 15 posts - 916 through 930 (of 1,131 total)