Topics
Started by
Posts
Last post
I have inherited a SQL 2008 R2 server that has a few instances of SQL Server on it. The DBA who kne…
2 replies
Hi, I was trying to get a "rule" for table naming but it's kind of hard to do it since every case i…
3 replies
I have the following table and fields: Table: tbl.transactions T Fields: T.visitid, T.diagnosiscode…
2 replies
I was recently asked for my opinion on adding an identity column and primary key to a very small ta…
9 replies
Example scenario. Current odbc connection on a workstation is to CLIENT_SQL\DATABASE. This databa…
3 replies
I have an issue with a large query, where the sort operation caused by a group by is costing over 8…
4 replies
Maybe what I try to do is a bit weird, but my thought there should be a way to do it without first …
2 replies
I got a job which runs daily having two steps 1. it truncates the present database. 2.It import the…
3 replies
Hi, I am looking for a script to find out all clustered indexes which are not in primary file group…
2 replies
Hello All, I have a scenario where i am looking to restrict a login only to read from the tables bu…
8 replies
Hi, we are having more than 3000 tables in our DB, But none of the tables are designed with foreign…
11 replies
Hello, I've got a very strange problem, I can send mail with the following statement: declare @Erro…
5 replies
How do we use SUM in side update statement. Please review the below query and help me select [Sept…
1 replies
we have all of our 1000 instances stored in a central DB. I can easily pull these out, and group an…
3 replies
Hi guys, I need some help (well a lot) with XML. I've never used it before so am basically green in…
7 replies
Viewing 15 topics - 14,536 through 14,550 (of 30,209 total)
You must be logged in to create new topics.