Topics
Started by
Posts
Last post
Hi we have a legacy application running on sql2005. We suspect part of our performance issues is f…
5 replies
Hi everyone! Which SQL data type is equivalent to Yes/No [ms access]? I am new to SQL[using sql exp…
39 replies
Does anyone have any experience using query notifications with a high volume of data changes and a …
3 replies
I have a big database and 75% space is taken by a table around 490 GB. Now I am told to partition t…
1 replies
Hi All. I'm planning to upgrade a SQL 2000 instance to 2005, and wondering what approach would give…
6 replies
In SQL 2005, can I partition a table to help with more row and page locks versus immediately jumpin…
2 replies
The BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/5b21c53a-b4f4-4988-89a2-801f512126e4.h…
13 replies
I have a table of 100 records. I need a random of 2.5% of the reocrds. If I use Select Top (2.5) Pe…
7 replies
We have a shared SQL server with a few hundred small DBs on it. Currently all the DBs consist of a …
21 replies
Hi folks, I have a question in regards to a design I've been pondering. Perhaps i'm merely over an…
23 replies
SQLServer2005 EE. Morning all, I need to identify records that are changed since 'last time' (e.g. …
1 replies
Hi, For error someone run DBCC CHECKDB in production database, now i want disable or cancel this co…
21 replies
Is it any impact on the performance if we join the two tables of the different database. my current…
6 replies
hello experts, i have some error in using "sp_delete_file" Stored procedure. so looking some other …
2 replies
Hi everybody...I"m new to SSIS, a tool my company is making us use primarily as a DTS tool. What I'…
3 replies
Viewing 15 topics - 16 through 30 (of 1,008 total)
You must be logged in to create new topics.