Viewing 15 posts - 1 through 15 (of 194 total)
please look into this area, explains more on MARS compatability with sql
November 2, 2007 at 8:46 am
You need to initate the data sources odbc with sybase to sql server first.
November 2, 2007 at 8:21 am
you need to sys-admin rights/permissions to do this job
November 2, 2007 at 8:15 am
Question of the Day for 26 Oct 2007 :-
Which functionality provides the best granularity of ownership of objects within SQL Server?
Correct answer: create objects with schemas
November 2, 2007 at 6:25 am
You can use the BLOB datatypes to store & retrive the information.
But the recommanded solution is,
- Store the Binary Objects in Common Server
November 2, 2007 at 4:59 am
open 2 instances of sql...
1) Test db.
2) Production db.
If u hav database publishing wizard, then point the connection string to testdb & relevant database.
That will run a...
November 2, 2007 at 4:05 am
You need to have sys_admin roles to perform any activity.
November 2, 2007 at 3:40 am
try out varchar
November 2, 2007 at 1:33 am
SQL Server 2000 Indexed Views are similar to Materialized Views in Oracle - the Result Set is stored in the Database. Query Performance can be dramatically enhanced using Indexed...
November 2, 2007 at 1:25 am
http://www.microsoft.com/technet/prodtechnol/sql/2005/dwsqlsy.mspx - Overview of Business Intelligence and Data Warehousing
http://msdn2.microsoft.com/en-us/library/ms173767.aspx - Introducing Business Intelligence Development Studio
Try to pull out some useful tip from the above...
November 2, 2007 at 1:19 am
Excellent way of showing the example with meaningful image clips for data extraction.
November 2, 2007 at 12:49 am
We can also use cursors for bulk inserts.
November 2, 2007 at 12:29 am
Implements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it is...
November 2, 2007 at 12:11 am
design your report in such a way that, bring or drag & drop the relevant fields into the detail column of the report. set the detail column property by showing...
November 1, 2007 at 11:47 pm
Version control means managing the versions of the objects created and deployed in their SQL Server environments. Typically, this involves developers and DBAs checking scripts including object creation scripts into...
November 1, 2007 at 11:42 pm