|
Sql Server
Data Management:
When the collation of your user database does not match the collation of TempDB, you have a potential problem. Temp tables and table variables are created in TempDB. When you do not specify the collation for string columns (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
A while back I wrote, “To SA or not to SA”. That blog touched my security side that I take very seriously in my database server landscape. I’m glad to have seen so many read the blog in hopes it brought attention to the SA (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
Collations control how strings are sorted and compared. Sorting is not usually a problem because it does not cause collation conflicts. It may not sort the way you want it to, but it won't cause errors. The real problem he (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
With SQL Server versions prior to SQL2005, the only way to store large amounts of data was to use the text, ntext, or image data types. SQL2005 introduced new data types that replace these data type, while also allowing all (Read More)
News Network:
Sql Server
Topic:
Database
WhatIs: Enterprise IT tips and expert advice:
DBAs have several techniques to choose from for ensuring SQL Server availability. Deciding on the right one for you is all about evaluating the costs versus the benefits.
. (Read More)
News Network:
Information Technology
Topic:
Server
Data Management:
I believe I have discovered a deadlock situation that SQL Server is not able to detect, so a perpetual block occurs.A deadlock is nothing more than mutual blocking. Blocking is when a process is forced to wait for a resource (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
I’ve found that many companies find out what true Disaster Recovery is only in the presence of a true disaster. Obviously this is not a very optimal time to start thinking about what could have done to keep the money flowing (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
When you use an undocumented stored procedure, you run the risk of not being able to upgrade your database to a new version. What's worse... you could have broken functionality and not even know it. With undocumented stored (Read More)
News Network:
Sql Server
Topic:
Database
WhatIs: Enterprise IT tips and expert advice:
A SQL Server Profiler trace can provide critical information on a problem query in a matter of seconds. Learn how – and when – to run the application.
. (Read More)
News Network:
Information Technology
Topic:
Server
Data Management:
The countdown to PASS has officially reset. Good news is we have under 365 days to go until the next PASS. Bad news is we have just under 365 days to go. It’s been great watching the tweets and laughs going back and forth (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
Best Practice: coding SQL Server triggers for multi-row operationsThere are many forum posts where people code triggers but these triggers are coded incorrectly because they don't account for multi-row operations. A trigger f (Read More)
News Network:
Sql Server
Data Management:
There can only be one clustered index per table because SQL Server stores the data in the table in the order of the clustered index . When you use a UniqueIdentifier as the first column in a clustered index, every time you i (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
I am writing this blog as an introduction to matrixes. In SQL Server 2005, Reporting Services has two main controls, tables and matrixes. Tables, however useful, only expand vertically. Matrixes, however, expand both horiz (Read More)
News Network:
Sql Server
Topic:
Database
Data Management:
By definition, primary keys must contain unique data. They are implemented in the database through the use of a unique index. If there is not already a clustered index on the table, then the primary key's index will be clus (Read More)
News Network:
Sql Server
Topic:
Database
News Networks:
Information Technology,
German It News From Idg
Topic:
Server
WhatIs: Enterprise IT tips and expert advice:
Both statements can be used to delete SQL Server data, but some situations call for one over the other.
. (Read More)
News Network:
Information Technology
Topic:
Server
Data Management:
Column names (and table names) should not have spaces or any other invalid characters in them. This is considered bad practice because it requires you to use square brackets around your names. Square brackets make the code (Read More)
News Network:
Sql Server
Topic:
Database
Submitted by hamed20
from Google Reader:
زمانی که به این مشتری سرزده بودم تا ببینم که اوضاع از چه قرار است یک کار نسجیده انجام دادم و آن اعلام این مساله بود که دستگاه ویروسی است . همان روز خودم آنرا فرمت کردم و ویندوز و همه چیزهای دیگر را مجددا نصب کردم .از همان ر (Read More)
News Networks:
Enterprise It,
Information Technology
Topic:
Server
Data Management:
Last week I wrote that SQL Server 2008 R2 Editions pricing has been announced, Microsoft today made availabe for download the SQL Server 2008 R2 November CTP. SQL Server 2008 R2 November CTP is available today for MSDN and Te (Read More)
News Network:
Sql Server
Data Management:
There are several string data types in SQL Server. There are varchar, nvarchar, char, and nchar. Most front end languages do not require you to identify the length of string variables, and SQL Server is no exception. When (Read More)
News Network:
Sql Server
Topic:
Database
Add something
|
||||
|
|
||||
