|
|
-
|
|
Recently a friend of mine asked for a script, for documentation purpose which can help them to create all of their indexes list with column names used in each index. I thought, I must share this simple script with my blog readers. ...
|
|
-
|
|
How to install Sql Server Management Studio???Why I can’t install Sql Server Management Studio???Unable to install Sql Server Management Studio??? SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for co...
|
|
-
|
|
Stored procedure is a set of Structured Query Language statements with an assigned name which are stored with in the database in compiled form so that it can be used by a number of programs. Ad hoc queries are normally written on application side and a...
|
|
-
|
|
Recently a blog reader shared an interesting thing. This mail was basically in response to my early post Why to Avoid TRIM functions in WHERE and JOIN clauses, where we have discussed, that why we should avoid functions (user defined or system) in where clause columns, because these functions in WH......
|
|
-
|
|
GUID or int as Primary key ???Though it is not necessary that your Primary Key column is always a cluster index too. By default, Sql Server creates cluster index on column or group of columns which you have declared as your table PK, and most of DBAs don'...
|
|
-
|
|
A blog reader asked that why should we avoid COUNT (*) and why it is declared fo...
|
|
-
|
|
To delete a record, with all of its reference records, in other tables is not an easy task, especially when database has dozens of tables and you have not designed your tables with cascade delete option. Then cascade delete in SQL Server is only possible b...
|
|
-
|
|
In every learning session of performance tuning we like to repeat one sentence “DON’T
EXECUTE THIS IN PEAK HOURS” or you must wait for peak hours to execute a specific
query. For example we should never execute REBUILD INDEX statement or FULL BACKUP
DATABASE statement in peak ho......
|
|
-
|
|
Exporting FILESTREAM (varbinary (max)) data through SSIS package from source database to FLAT FILE destination and then loading from FLAT FILE to destination database, was a time consuming task for ME, at least. L...
|
|
|
|