sp_MSforeachtable
Is sp_MSforeachtable the best approach to maintain the rebuilding of all
indexes
for all tables in a database?
thanks in advance,
...bob
| | 0 | 35 | 11/11/2009 3:37:07 AM |
SQL Server "insert", rows wnot immediately visible to other clien ts
I have a T-SQL stored procedure that inserts a row into one table, then
inserts a row into another table, both tables in the same database.
Both inserts are bracketed by begin trans/commit | | 0 | 36 | 11/11/2009 2:53:02 AM |
DBCC CHECKTABLE('owner.tablename') Question
Hi,
In my SQL Server 2000.
I use the command DBCC CHECKTABLE('A.TableA') and DBCC
CHECKTABLE('A.TableB').
The Rows number for both TableA and TableB are approximately the sa | | 0 | 29 | 11/11/2009 1:53:33 AM |
AdventureWorks database
Hi
Sql book I=92m reading uses extensively AdventureWorks database. But
it=92s very difficult to follow since I don=92t know what exactly the
tables and their columns represent ( | | 0 | 35 | 11/10/2009 9:36:42 PM |
Copying data
On a one time basis, I need to copy data from one database/table to
another.
DB1/TBL1 (Database 1 / Table 1)
Columns
Time1(datetime, null)
Value1(float, null | | 0 | 40 | 11/10/2009 7:26:39 PM |
Find approximate values
I have a Stored procedure I am trying to get to work that will look for
approximate values. In otherwords, values where the person entering the
data may have mistaked a "0" for | | 0 | 41 | 11/10/2009 7:24:46 PM |
Using bcp in command line with store procedure
I created a store procedure(e.g sGetData) to process data.
For security reason, I have to use command line using BCP to export the
result of store procedure to a XML file to another file ser | | 0 | 38 | 11/10/2009 7:20:45 PM |
filtering rows based on values in one column
HI
USING SQL 2008
The query below returns rows where roleid = 3 and should not. If I'm looking
at the same column and want to return those where the value equals a value
< | | 0 | 38 | 11/10/2009 5:48:35 PM |
Update Table from Dense_Rank Function
I need some help.
Basically I have a query that returns if a patient has multiple
diagnosic codes using the Dense Rank Function.
SELECT * INTO #tmp_GridResults_1
FROM (
| | 0 | 43 | 11/10/2009 4:38:41 PM |
Return specific number of reords per ID
Hopefully this makes sense....
I have a table that contains over 20,000 records. The records are based off
a company id. How can I return the up to the first 50 records of each
| | 0 | 47 | 11/10/2009 4:10:16 PM |
looping
Hi... i have been testing using cursor's.
looping through a select statement, I want put a numeric field into a temp
value ..
declare My_cursor cursor
for
select | | 0 | 48 | 11/10/2009 3:56:21 PM |
Export a store procedure to XML file?
I created a store procedure, getOrder, to select data.
How to export "getOrder" to a xml file in d:\order?
--
Message posted via http://www.sqlmonster.com
| | 0 | 39 | 11/10/2009 2:42:17 PM |
sp_send_dbmail
HI,
I'm running SQL2008. I have an internal website that log's onto the SQL
server using SQL login. I have tried sending an email using Sp_send_dbmail
with no attachment ant i | | 0 | 42 | 11/10/2009 2:42:16 PM |
Online Pharmacy, Discount Drugs Online, No Prescription Drug .
Pharmacy Online provides Brand and Generic medications such as viagra,
cialis, levitra, clomid, evista, fosamax, propecia, allegra, kamagra,
zyban. Buy generic medications. Worldwide Shippin | | 0 | 49 | 11/10/2009 12:44:19 PM |
Script to grant Permission
Hi,
How can I grant a read/write permission to a User for only two tables (a,b)
in a database ?
Thanks in advance
Suresh
--
Message posted via http://w | | 0 | 43 | 11/10/2009 10:36:17 AM |
Backing up data between SQL Express 2005 and SQL Server 2008 Standard Edit ion
Hi,
I am developing an application which needs to backup data between SQL
Express 2005 and SQL Server 2008. My client runs with an installation
of SQL express 2005 and needs to pe | | 0 | 42 | 11/10/2009 10:06:17 AM |
SQL Server Views - Missing Column Names ???
Hi there,
I have a local SQL Server (2008) on which I created a Linked Server
(to another SQL Server 2008 box).
The problem I'm having is that whenever I create a View again | | 0 | 42 | 11/10/2009 7:40:51 AM |
14 byte date/time in file name
Hello everyone,
Anyone know how I can be guaranteed a 14 byte string from this sql code:
SET @outputfile = ltrim(DATEPART(year, GETDATE()))
+ ltrim(DATEPART(month, GET | | 0 | 45 | 11/10/2009 7:40:46 AM |
Making content more readable -- please help!!
Hi,
I want to write an sproc that I can run on a particular column of a
particular table that takes the contents of the row and uppercases
every first letter and lower case | | 0 | 46 | 11/10/2009 7:40:43 AM |
Partition Range Script
I am partitioning by a date column in SS 2005 SP3. So I ran my script and
create partitions and all is well. However, I can't find the nifty query
that I ran across that the max/min date | | 0 | 31 | 11/10/2009 7:40:42 AM |
milliseconds in datetime variable.
Hi,
I am wondering how to compare 2 datetime values so that milliseconds are
taken into account.
as an example I have the following script.
it appears that | | 0 | 44 | 11/10/2009 7:40:37 AM |
creating table on secondery filegroup
hello there
i have database with two filegroups and for each filegroup there is diffrent
file name
How can I use Select .. into and create new table on secondery filegroup? | | 0 | 28 | 11/10/2009 7:40:31 AM |
Sql Server on VMWare
Hi,
Can anybody give me some right direction or usefull link
1. About VMware environment
2. How to Install and configure Sql Server 2005 on VMware.
3. Is there any performanc | | 0 | 39 | 11/10/2009 7:40:27 AM |
Free Tools for SQL Server - SQLsoft.co.uk
Hi All,
We've written a number of (I think!) handy tools over the past few
months which are available from here: http://www.sqlsoft.co.uk/
Newly released is SQLscripta, whic | | 0 | 46 | 11/10/2009 7:40:21 AM |
Transaction load
Hi there,
I have an app that needs to upload a lot of files into my DB, where each
file will typically be perhaps 400K but can max out at 16MB (though that
would be very rare). | | 0 | 45 | 11/10/2009 7:40:19 AM |
Modify statement to run sp_executesql
To learn sp_executesql, I create a small code. It works fine as below.
CREATE TABLE [dbo].[#A](
[authno] [nchar](10) NULL,
[Authname] [nvarchar](50) NULL
) ON [PRIMARY]
| | 0 | 42 | 11/10/2009 7:40:18 AM |
SQL 2008 - FILESTREAM OpenSQLFilestream invalid handle
SQL 2008 Express running in Virtual PC on Windows XP Pro, accessed from a
"real" machine with Windows XP Pro via TCP/IP and sql authentication (the
server has enabled mixed mode) | | 0 | 39 | 11/10/2009 7:40:16 AM |
Database Table Design
I have a [user] who belongs to a [group] and writes an [article] using a
certain [computer].
The user can move to a different group and a computer can be assigned to a
different perso | | 0 | 40 | 11/10/2009 7:40:14 AM |
SSIS hitting FK violation - need to ignore the error rows - have package s ucceed
I'm using SSIS and i'm getting a FK violation in my OLE DB Destination
task. I'm getting a FK violation and would like to ignore any rows
(throw them away) where the error is encountered. | | 0 | 44 | 11/10/2009 7:40:09 AM |
Output only 255 characters
I have a stored procedure that builds insert statements for the table I
pass.
This procedure works perfect at my office. But at my client site, it doesn't
seem to work correctly | | 0 | 37 | 11/10/2009 7:40:02 AM |
Date Range
Newbie. I can not seem to figur out the DATEDIFF. I have a simple Select
Select * from Table Where Date = > (1st day of LAST year) and Date <= (Last
Day of LAST year).
< | | 0 | 38 | 11/10/2009 7:40:01 AM |
Call for speakers for LinkedData Planet (June 17-18, 2008 in New York City)
| | -1 | 94 | 2/15/2008 3:11:03 AM |
Strange control-of-flow problem in T-SQL
I cannot figure this out. If you run the following code to create a test db
and add a table, such as:
CREATE DATABASE dbtemp;
USE dbtemp;
CREATE TABLE [application] (
c1 INT | | 7 | 94 | 2/6/2008 8:12:03 PM |
Book on schema design
Can anyone recommend some good books on schema design? I have read through
a buch of threads in this forum and see a pattern of bad design issues which
seem to crop up. I am looking for a | | 1 | 117 | 2/6/2008 8:08:32 PM |
Need help with a query
This is a multi-part message in MIME format.
------=_NextPart_000_000A_01C868C9.C22C56A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printabl | | 3 | 115 | 2/6/2008 8:03:35 PM |
Finding similar company names in table
I have a table of client companies (Create Table Query given below), mainly
law firms, actually. The same
firm may occur several times because of various locations, etc. The
complicating | | 0 | 102 | 2/6/2008 8:03:21 PM |
Help with basic Group By mis understanding please
I am using a book which doesn't give the clearest of explanations and
wonder if someone could clear this up for me.
Select SalesPersonID, TerritoryID, Count(*) from
Sales.SalesOrderHe | | 4 | 103 | 2/6/2008 7:39:11 PM |
DateTime, Date and Time?
Is there a reason sqlserver doesn't have a Date and a Time datatype? I can
kind of see why there is no Date data type but why not time? Are they trying
to future proof sqlserver by not locki | | 17 | 105 | 2/6/2008 7:11:54 PM |
search between strings...
Hello.
I have to some data i'm pooling from a table that has special chars like (<,
% ,>) I need help help extracting the data and eliminating the chars.
e.g. this is a | | 5 | 112 | 2/6/2008 7:11:04 PM |
table naming convention confusion
am learning sql server 2005 using sql server 2005 express and the
book beginning c sharp 2008 databases from novice to professional.
I'm using the advertureworks database, and notice tha | | 3 | 117 | 2/6/2008 6:59:07 PM |
Dynamic SQL execute as calling user?
I have a sproc that I want to use dynamic sql for (i have my reasons) and
this is in SQL Server 2005 with the latest service pack... I noticed you can
do
EXEC(@sqlstatementhere) AS | | 3 | 105 | 2/6/2008 6:34:08 PM |
SQL data type question
I'm looking at a conversion table between sql data types and .net data
types. I don't understand what a few of the sql datatypes are and where/how
they would be used in sql server.
| | 1 | 110 | 2/6/2008 6:31:40 PM |
Is Celko really Chuck Norris of the SQL World?
After many years on this forum I never get tired of Joe Celkos comments, they
are usually arrogant in the extreme but kinda funny too.
So to parody the Chuck Norris jokes...
Cel | | 3 | 109 | 2/6/2008 6:22:54 PM |
row level security
I need to restrict access to reporting tables based on row level criteria.
Depending on the geographical location, a user should be allowed to query
data against tables for their own geograph | | 2 | 101 | 2/6/2008 6:19:01 PM |
One to One relationship
Hi, I have a table called provider, which contains the following column:
CompanyName; CompanyID; C; D; E; F; G. Column CompanyName and Column
CompanyID should be one to one relationship, me | | 5 | 111 | 2/6/2008 5:57:49 PM |
ANSI_PADDING deprecated?
Hi,
A question to the SQL Server architects @ Microsoft:
I came across in the section on SET ANSI_PADDING in the Books Online
that this feature will be removed in latter version | | 2 | 95 | 2/6/2008 5:53:39 PM |
Boolean/Bitwise Expressions
I can't seem to figure out why I get an error "Incorrect syntax near '='"
when I try to compare a bitwise expression with a regular number and return
0 or 1. It seems I should be able to get | | 4 | 95 | 2/6/2008 5:22:22 PM |
Set a global filter on a table
I work a huge kind of ugly project where we have lots and lots of
tables in the database, the calls to the database is spread out across
multiple projects,sp's, SSIS and so on.
We hav | | 8 | 106 | 2/6/2008 5:05:57 PM |
FullText Index Search
I have a simple music catalog:
CREATE TABLE [dbo].[Catalog](
[CatalogId] [int] IDENTITY(1,1) NOT NULL,
[Artist] [nvarchar](256) NULL,
[Title] [nvarchar](256) NULL,
[Remix] | | 0 | 106 | 2/6/2008 4:22:12 PM |
Audit:Login
Hi
SQL Server 2005 SP1
In Profiler I see a great number of Logins /Logout.
This is a web enviroment and the site is active but the number of Logins
seems too large | | 6 | 108 | 2/6/2008 4:14:52 PM |