Topics
Started by
Posts
Last post
I have MS SQL 2008 and I have been running it for over a year. Last night I decided that I wanted …
1 replies
I need to print the results off my server of this query Select * from orders WHERE warehouseid='c' …
3 replies
I am having very high read wait times on our OLTP system and would like to prove to our SAN vendor …
2 replies
Hello, I understand that it is good practice to create the same number of Tempdb's as you have proc…
3 replies
CREATE TABLE [dbo].[emp_stage]( [empid] [smallint] NULL, [ename] [varchar](7) NULL, [rowid] [int…
6 replies
Thanks for your help in advance. I am trying to edit some xml <resRefDate> <refDate>201…
2 replies
I found an interesting behaviour in SQL Server 2008: I have a query like this: (I know it could be …
3 replies
Hi, what is the difference between row_number and top functions in sql server
2 replies
Hey All, Is there a script to detach database w/ forcing to drop any existing connections? We have…
7 replies
I have a table with date ranges. I need a way to reject conflicting rows. How can I reject overlapp…
6 replies
Hi All, I am a newbie here, I have a table with 600K row, assume the table name is tbsales and it h…
5 replies
Dear all, I'm new to this site. I need help to write a query for selecting from two tables. I have …
6 replies
I wand help for how to rollback the transaction.
1 replies
CREATE TABLE 'Orders' ('Orderdate' VarChar(99999999999999999)NOT NULL default '', 'Orderid' VarCha…
1 replies
Hello All, I am trying to rename the sql server name; when i tried to use the select @@SERVERNAME…
1 replies
Viewing 15 topics - 25,336 through 25,350 (of 30,225 total)
You must be logged in to create new topics.