| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I have inherited a system where the previous DBA added 7 data files to
the PRIMARY filegroup and left the AUTOGROW option at 8MB. What I have
now...
joshsackett
|
06-24-2011 03:07 PM
Fred.  | 2 | 3 |
| | | Now you don't need to worry about passing the certification exam
Hello guys,
Now you don't need to worry about passing the certification exam.
Visit...
miss salwa
|
06-21-2011 12:32 PM
miss salwa | 0 | 1 |
| | | Now you don't need to worry about passing the certification exam
Hello guys,
Now you don't need to worry about passing the certification exam.
Visit...
miss salwa
|
06-21-2011 12:32 PM
miss salwa | 0 | 1 |
| | | Can I generate an identity column when importing using BCP that will
sequence by the physical order of the records?
blindsey
|
06-18-2011 05:29 AM
Erland Sommarskog | 6 | 7 |
| | | A few weeks ago I posted an article about a problem I was having with
SQLExpress 2008. See it...
Joe Cool
|
06-17-2011 10:43 AM
Mark D Powell | 4 | 5 |
| | | Hello all
This is Umesh Jadhav running Spark Technology Institute
Well we are really happy to see that we are really provide such a
quality high...
umesh
|
06-17-2011 10:05 AM
umesh | 0 | 1 |
| | | Certification training bootcamps and latest braindumps
Hello Friends,
If you are looking certification training bootcamps and latest
braindumps then...
miss lulu
|
06-15-2011 11:28 AM
miss lulu | 0 | 1 |
| | | hi, everyone, thanks for your reading. I have met with some problem
when using otl to program for the database. And my development
environment is...
white_ideal
|
06-14-2011 08:33 PM
white_ideal | 8 | 9 |
| | | Watch the Video
http://www.youtube.com/watch?v=KHlpwxnKS5o
Enhanced usability
Yellowfin 5.2 also includes a number of enhancements directly...
janpelletier@yahoo.ca
|
06-14-2011 08:35 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Hi There,
I got to know of an exciting event happening in Mumbai on June 25th
I guess it will add a great value to all the HR professionals,
The...
Events Execution
|
06-13-2011 12:27 AM
Events Execution | 0 | 1 |
| | | Hi!
I have a table that keeps track of the
system numbers that my system needs to issue.
This is a Warehouse Control System. So the type of numbers...
björn lundin
|
06-12-2011 06:05 PM
Erland Sommarskog | 5 | 6 |
| | | Hi!
In other databases, the prompt-tool offers a way of doing dml/ddl
statements.
They usually have a way of describing objects in the db as well
I...
björn lundin
|
06-12-2011 04:04 PM
björn lundin | 2 | 3 |
| | | MAKE ALL IT CERTIFICATIONS - A PIECE OF CAKE Hello Friends, Nowall IT Certifications like MCSE, MCTS, MBS, SCJB, A+, CCIE, CCNA, CCNP,Oracle 10g 9i, IBM, HP, Vmware and many more are made a Piece of Cake. Visit MAKE ALL IT CERTIFICATIONS - A PIECE OF CAKE
Hello Friends,
Now all IT Certifications like MCSE, MCTS, MBS, SCJB, A+, CCIE,
CCNA, CCNP, Oracle 10g...
miss salwa
|
06-12-2011 02:02 PM
miss salwa | 0 | 1 |
| | | Hello,
I have a table (Main) with compound key and second, temporary table
(Temp) with same fields but without PK. Main table key is 3 columns
(...
Richard
|
06-10-2011 10:50 AM
Richard | 4 | 5 |
| | | how can I read the documentation when I´m offline ?
Is there a PDF version available for SQL server 2008 R2 ?
Where can I find it ?
RabasMa1@web.de
|
06-09-2011 09:42 PM
Gene Wirchenko | 6 | 7 |
| | | Hello all
This is Umesh Jadhav running Spark Technology Institute
Well we are really happy to see that we are really provide such a
quality high...
umesh
|
06-09-2011 10:37 AM
umesh | 0 | 1 |
| | | I have an order table which has item, order creation and cancelation
times. Canceled order records have cancel time in them, regular orders
have NULL...
migurus
|
06-08-2011 08:33 PM
migurus | 2 | 3 |
| | | Tom Gugger
Independent Recruiter
tgugger (AT) bex (DOT) net
MS SQL Developer/ Career Position/ Lansing, MI
Our client has a career opening for an...
TOM
|
06-07-2011 10:14 AM
TOM | 0 | 1 |
| | | Hi!
I've got a problem that I do not really understand,
and I am of course wondering if anyone could
enlighten me.
I have a system, ie several...
björn lundin
|
06-05-2011 01:31 PM
björn lundin | 6 | 7 |
| | | International Business Intelligence (BI) vendor, Yellowfin, has been
recognized amongst the world’s elite BI vendors, outperforming
established...
janpelletier@yahoo.ca
|
06-05-2011 08:55 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | I a having problems with SQLExpress 2008 on a Windows 7 x64 Ultimate
computer. Installation goes just fine, my username is an
administrator. I am...
Joe Cool
|
06-05-2011 01:42 AM
Henk van den Berg | 1 | 2 |
| | | Webinar launch to show how Yellowfin 5.2
International Business Intelligence (BI) vendor, Yellowfin, has
announced that it will launch the new...
janpelletier@yahoo.ca
|
06-02-2011 10:13 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | We accumulated quite a collection of sql scripts, which are stored as
a plain text files in several directories. We'd like to create a
documentation...
migurus
|
06-01-2011 02:14 PM
migurus | 0 | 1 |
| | | Dear SQLers:
I am trying to get around some of the limitations of T-SQL.
I wish to run a preprocessor over script files much as the C
preprocessor...
Gene Wirchenko
|
05-26-2011 06:24 PM
Gene Wirchenko | 9 | 10 |
 | | Hi Experts,
I need help to write a query in SQL server 2008. Below is my table
structure.
My table is having four...
Dinesh
|
05-26-2011 09:19 AM
--CELKO-- | 16 | 17 |
| | | I have had to do maintenance work on a number of databases that have
been created using what seems to me a very complex structure.
For instance,...
stapes
|
05-25-2011 05:32 PM
Erland Sommarskog | 2 | 3 |
| | | What are the differences between the two?
Is there an advantage to use R2?
Is there any reason to even use the non-R2 version?
Joe Cool
|
05-20-2011 05:52 PM
Joe Cool | 3 | 4 |
| | | We have a couple of databases on 2 different MS SQL 2005 Express
servers that every week or so will be unaccessible. When we try to
access the...
Admin Matt
|
05-20-2011 09:43 AM
Admin Matt | 7 | 8 |
| | | Dear SQLers:
I am working with error handling. I have Erlang's code for error
reporting. He suggests
if @@tranlevel>0
rollback
I have removed this...
Gene Wirchenko
|
05-20-2011 03:32 AM
Erland Sommarskog | 7 | 8 |
| | | Well, we've finally set up a new server and installed 2008 on it (Denali?
What's that?). Anyway, I hit my first hurdle: Integration Services would...
Bob Barrows
|
05-19-2011 05:42 PM
Erland Sommarskog | 1 | 2 |
| | | Macquarie University today launched the first phase of a university-
wide reporting and analytics program, Datamart.
Datamart, powered by...
janpelletier@yahoo.ca
|
05-18-2011 08:04 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Macquarie University today launched the first phase of a university-
wide reporting and analytics program, Datamart.
Datamart, powered by...
janpelletier@yahoo.ca
|
05-18-2011 08:04 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | hi,
I need to compile stored procedures and functions larger than
8000bytes on Sql Server 2005.
I even tried CLR procedure, but unfortunately it...
avcitamer
|
05-18-2011 07:59 AM
avcitamer | 5 | 6 |
| | | The following query will return one row for each pkLoanID present in
the queried table:
SELECT pkLoanID FROM Loans
So, if there were three records,...
BobRoyAce
|
05-17-2011 10:41 AM
BobRoyAce | 0 | 1 |
| | | Thanks...just what I needed.
BobRoyAce
|
05-17-2011 10:34 AM
BobRoyAce | 0 | 1 |
| | | Hi everyone,
We are trying to come up with ideas to ultimately create and send a
csv file (comma seperated value)
attached in an email via Stored...
George Lewycky
|
05-16-2011 09:03 PM
George Lewycky | 0 | 1 |
| | | Hola a todos! Buscamos URGENTE Dvelopers .NET y SQL SR.:
Esta persona se va a tener que encargar de tres cosas:
1) De llevar adelante el...
julia martinez
|
05-14-2011 01:40 AM
julia martinez | 0 | 1 |
| | | Dear SQLers:
I wish to define some user-defined errors. For example:
execute sp_addmessage
@msgnum=50001,@severity=16,
@msgtext=N'String %s has...
Gene Wirchenko
|
05-13-2011 05:27 PM
Erland Sommarskog | 3 | 4 |
| | | Greetings everyone,
I'm administering a SQL Server 2008 R2 and I have a daily maintenance
plan that backs up a database and then reorganizes it's...
SGoncalves
|
05-11-2011 06:22 AM
SGoncalves | 11 | 12 |
| | | I process a weekly extract which, unfortunately, comes from a table
with a 20 unvalidated integer fields which I need in the form of
numbers when...
Fred.
|
05-10-2011 03:50 PM
Fred. | 5 | 6 |
| | | Hi everyone,
I got this situation, I got a stored procedure that for some reason
after using it for some period of time (maybe a day or two) ...
Wishmaster
|
05-09-2011 05:52 PM
Erland Sommarskog | 7 | 8 |
| | | Dear SQLers:
I want to post batches of transactions. The transactions have to
pass various checks. The transaction must balance to zero. ...
Gene Wirchenko
|
05-07-2011 12:31 PM
Henk van den Berg | 4 | 5 |
| | | Dear SQLers:
I have been digging into cursors. It appears that one can not
modify a cursor variable passed as a parameter. Being able to do...
Gene Wirchenko
|
05-07-2011 05:51 AM
Erland Sommarskog | 2 | 3 |
| | | I am trying to create a Linked Server from MS SQL server Management Studio
to a MDB file on a 2nd Server.
Using Windows authentication I can query a...
ron paii
|
05-06-2011 03:51 PM
ron paii | 5 | 6 |
| | | Hi everyone.
I have done quite a bit of research on this, but could not find a good
answer. I need to get the UNC path from a mapped drive letter...
Matthew Wells
|
05-02-2011 11:02 PM
Henk van den Berg | 7 | 8 |
| | | Hi,
I am using SqlPubWiz.exe command line to generate scripts for entire
database but i couldn't find a command line parameter that will allow
me to...
omtechguy
|
05-01-2011 05:11 AM
Erland Sommarskog | 1 | 2 |
| | | This AM a database on my dev box is listed as being in recovery. I
checked the sql server log (in SSMS Management/SQL Server Logs) and all
it says is...
mat
|
04-29-2011 02:05 AM
Henk van den Berg | 12 | 13 |
| | | 1. Where are triggers shown on the Object Explorer in SSMS? I
thought they would be listed under "Programmability ... Database
Triggers" but they...
Dom
|
04-27-2011 06:02 PM
Erland Sommarskog | 14 | 15 |
| | | Sex sells. And, although it may seem absurdly out of context, it
definitely sells Business Intelligence (BI) software.
Though somewhat ironic, many...
janpelletier@yahoo.ca
|
04-26-2011 07:43 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Dear SQLers:
I think I have just managed to enable Unicode on my Windows XP
system. Some stuff does not seem to be displaying correctly. Some
has....
Gene Wirchenko
|
04-26-2011 03:15 AM
Erland Sommarskog | 2 | 3 |
