All, I am using third party tool WIN SQL to connect to SQL Server Database.I am wondoring is there any SQL command to get table/column definitions...
Two days ago i downloaded toad trial version and installed on my machine to use SQL server database.When i try to connect to SQL Server Database,i am...
HI ALL, Is there any way to disable or enable index on sqlserver table instead of drop/recreate index? Thanks, Sriram.
Hi ALL, I tried to drop table from database by using query analyser its running forever... Is any clue why i am not anle drop that table. Thanks,...
HI ALL, How to clear log files in sqlserver database? Thanks, Sriram.
Hi ALL, I have a dimension table with identity column(STORE_KEY).When i tried to update that table on column2,its updating the identity column n...
HI ALL, WHEN I am querying data using sql statement SELECT Col1,COL2,COl3.. UNION SELECT Cil1,col2,col3.. UNIon ... ... I am getting the following...
Hi ALL, I got a large Data warehouse table with 10 million records, when i am querying that table performance is very slow.So i am planning to...
Hi ALL, I was trying to run a query on query analyser I am getting following error,eventhough i got 57GB free space on my database. "Could not...
Hi All, I allocated 45 GB to my database i.e datafiles size 35GB and Transaction log size 15GB.i tried to resize my database to 35 GB.How do i lower...
Hi ALL, My datawarehouse table contains around 10 million rows.When i tried to query that table, i am getting the error says " [Microsoft][ODBC SQL...
Hi All, My source column is Char(i.e'2004-01-19')data type.I wwant to insert this value into sqlserver table datetime column,is there any function...
Hi, I am new to SQLSERVER.Is there any object(i.e sequence in oracle) in SQLSERVER to maintain uniqueness in table? Thanks in Advance.
Separate names with a comma.
