SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Server level trigger at Database level...

  My boss found a table in live data that we can't account for on who created it or what it's for. B…

  John Waclawski

  2 replies

  15 years, 3 months ago

  By: John Waclawski

• NOOB DOUBT: Storing data into 2 related tables

  CREATE TABLE Person ( Person_id INT NOT NULL IDENTITY(1,1) PRIMARY KEY, last_name VARCHAR(20) ,…

  sithlordvarun

  3 replies

  15 years, 3 months ago

  By: rjv_rnjn

• Slelect Problem: kind of like a pivot but different

  Hi, I'm currently working with a table that stores several types of information on employees. The t…

  nsontag

  7 replies

  15 years, 3 months ago

  By: LutzM

• execute .dtsx (ssis pkg) file via window schedule task.

  Hi All, How do i run a sql 2005 SSIS package (dtsx) file system under windows event/task schedular…

  keyun

  1 replies

  15 years, 3 months ago

  By: thasteve

• Finding Page Splits

  Anyone know if there's a DMV that tracks page splits? I need some kind of indication as to number o…

  Gail Shaw

  18 replies

  15 years, 3 months ago

  By: michael bourgon

• Top 1 by group query

  I have been struggling with this one for ages and therefore hoping someone will take pity on me and…

  pedrosmith

  11 replies

  15 years, 3 months ago

  By: pedrosmith

• recompilation due to deferred name resolution

  I 'm wondering do we have to qualify the sql objects (like procs) when the sql user has a default s…

  Hollyz

  5 replies

  15 years, 3 months ago

  By: Brandie Tarvin

• How to minus one hour from datetime value

  Hi all, I have a variable @tothr of datatype datetime. I want to minus one hour if hour is not less…

  sachinrshetty

  5 replies

  15 years, 3 months ago

  By: ColdCoffee

• Alert message when production server instance is down

  Hello folks, I wanted to create an alert when one of my production server instance is down....How d…

  Sandy2704

  2 replies

  15 years, 3 months ago

  By: Steve Jones - SSC Editor

• Finding out queries executed during a business day

  Hello folks, How do i find out the number of query executions against a particular database during …

  Sandy2704

  3 replies

  15 years, 3 months ago

  By: Sandy2704

• Need help on trace a job

  Hi All, Can someone help me to set up a trace to monitor a job? One of my clients is saying that sh…

  moosamca

  2 replies

  15 years, 3 months ago

  By: Atif-ullah Sheikh

• what are the roles and responsibilities of sql server dba job?

  hai, what are the roles and responsibilities of sql server dba job?

  sairamsqldba

  4 replies

  15 years, 3 months ago

  By: Atif-ullah Sheikh

• Stored procedure gives no compilation error but gives a run time error

  Consider this test procedure ----------------------------------- /*exec usp_tester*//****** Objec…

  vernalrd

  6 replies

  15 years, 4 months ago

  By: vernalrd

• Oder by a particular value

  Hi All, I have written a query like this: select 0 as rid,'ALL' as UserName union select rid,UserNa…

  malavika.ramanathan

  4 replies

  15 years, 4 months ago

  By: Dave Ballantyne

• Outputting sql query into flat file (txt)

  I'm using windows server 2003 with microsoft server enterprise sql manager which has a huge db stor…

  ender.nguyen

  3 replies

  15 years, 4 months ago

  By: Joie Andrew