Search Results | SQL Server Performance Forums

select from where group by

Thread by: a8le, Jul 4, 2007, 8 replies, in forum: General DBA Questions

Hi all, How do we SELECT, FROM, WHERE, and GROUP BY all at once? The store proc below works, but I want to "group by" ForeignKeyID? CREATE...

redundant posts

Thread by: a8le, Apr 26, 2007, 12 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Is there a simple way using SQL to prevent redundant posts? I have a script that accepts post from users, it works and all. But if the...

renaming registered severs

Thread by: a8le, Oct 30, 2006, 2 replies, in forum: General DBA Questions

hi all, how do we rename server when we are registering them... in MSSQL Enterprise Manager? thanks in advance, a8le http://www.noteful.com -...

synchronizing tables

Thread by: a8le, Oct 29, 2006, 2 replies, in forum: General DBA Questions

hi all, i have recently moved my website from one hosting company to another. everything (files and db) has finally be transferred over to the new...

storing images

Thread by: a8le, Jun 26, 2006, 4 replies, in forum: General DBA Questions

hi all, i am working on giving my users the ability to upload images to my site, and after some research i learned that i have the choice of storing...

no full text search

Thread by: a8le, Jun 21, 2006, 1 replies, in forum: General DBA Questions

hi all, my hosting package doesn't include full text cataloging... is there a way to have/get full text search capabilities without having it?...

sort by date two different tables

Thread by: a8le, Jun 19, 2006, 12 replies, in forum: General DBA Questions

hi all, how do we do a date/time sort(desc) for entries made in two different tables? my tables---> table1: myblogID (PK) myblogTEXT (varchar...

one stored procedure?

Thread by: a8le, May 31, 2006, 8 replies, in forum: General DBA Questions

hi all, i have recently been adding to my website... which included me adding several different stored procedures pulling data from different...

blog with poll help

Thread by: a8le, Apr 21, 2006, 14 replies, in forum: General DBA Questions

Hi all, I have a blog table... myBlog(Table) BlogID (primary key) Text(varchar 8000) Date(datetime) that has another associated table......

selecting an avg of a column with grouping

Thread by: a8le, Apr 20, 2006, 8 replies, in forum: General DBA Questions

hi all, i need some advice on what is the best way to sort/order by an average of a column... don't understand?... lol... details... i have two...

primary keys and foreign keys

Thread by: a8le, Apr 11, 2006, 5 replies, in forum: General DBA Questions

Hi all, I need to be schooled a little on primary keys and foreign keys... can you guys suggest any good tutorials? Here is my stituation, I have...

dynamically add columns using stored procedure

Thread by: a8le, Apr 10, 2006, 6 replies, in forum: General DBA Questions

hi all, i am trying to add a commenting system to my site, and need help dynamically adding columns to the comments table... i google "dynamically...

"insert into" and "select" combo

Thread by: a8le, Mar 26, 2006, 21 replies, in forum: T-SQL Performance Tuning for Developers

hi all,<br /><br />is it possible to do a "insert into" and "select" combo in a stored procedure? i have a stored proc that inserts data into a...

select the last entry with condition

Thread by: a8le, Dec 4, 2005, 12 replies, in forum: T-SQL Performance Tuning for Developers

hi all, can someone please explain to me why this isn't working? I have a store procedure that selects text from the the latest entry... CREATE...