Can someone suggest how to reduce the data file unused space which was increased after the reindex processes. Do not want to shrink the file since it...
Hello, I would like to know how the TFS database backups are scheduled by default? When i checked in SQL server agent job, there is no job scheduled...
Guys, How do I script out all the database objects with IF EXISTS clause. I need the script like below IF EXISTS (SELECT * FROM sys.objects WHERE...
Hi Guys, I have a table with more than3 Billion records nad tried to rebuild the indexes. the rebuild has ran around 16 hours but still not finished...
Hi Guys I have an issue with dm_db_index_physical_stats, it is taking long time (around 30 Min) to retrive the result against a table having 50...
Hi Guys, I have a table, below is the sample script, i tried to pivot the table based on the status (below mentioned query) i am getting 1 record...
Hello all, I have a migration project, some time I need to compare the databases (both source and target db are sql server 2008), since the data may...
create table #test(id int, name varchar(100)) insert into #test values (1,'aaa') insert into #test values (2,'bbb') insert...
Hi, Can any body give the script to get the table type definition (sql script). What are the sys objects needs to joing to get the definition? Thanks...
Hi guys, Need help I have a table with below mentioned records, I need to get the unique id group by some other field. Below is the sample table and...
Hi, Can anybody tell me, what are the steps need to consider while set a database server? Thaks
Hi Guys, Is it possible disble the transaction log for the dml stament for table? OR how can we avoid loging the data while creating the table? We do...
Guys, I have 2 xp machine (SP2), one is in physical machine and another in vmware over the same machine. I installed SQL server developer edition...
Hello, I am having an issue while creating MS Access as a linked server in SQL server 2000. When i tried the .mdb file without password, it is...
Hi, I am facing issue when i try to back up the SQL 2005 database to a shared drive in different server. Database is using the userid for login is...
Hi, How can we append an existing flat file with a query result [it may be more than one records.] i tried this way, however, it will delete the...
Hi,I have a doubt on remote data base access.(1) When we log on the server remotely and execute a query [say a select stmt.] how the data transfer...
Hi, I have a Modified Date Time field in one of my audit table, which has billion records, not indexed. The issue is, when i query out by passing...
Hi, Is it possible to do a sql server clustering in in a VM ware environment? I have a windows 2003 server with vmware instaled..on top of that can...
Separate names with a comma.
