Mike.Hahn

Forum Replies Created

Viewing 15 posts - 46 through 60 (of 131 total)

RE: Changing Database Name But need to Alias the Old Name, Possible?

EthanZ (2/5/2013)
I administer a SQL2008 server, the server is being handed over to another dept to manage, they are moving over all the databases and maintaining all roles etc. Once...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

February 5, 2013 at 3:01 pm

#1584627
RE: conditionnal auto-increment

The link you are referring to is the first one in my signature. Unfortunately it doesn't do much good here because the OP is " in charge of creating a...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

February 5, 2013 at 10:35 am

#1584515
RE: conditionnal auto-increment

Welcome... it would help if you provided DDL and sample data and what you expect to see as a result. There's a link to a posting guide somewhere, one...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

February 5, 2013 at 10:06 am

#1584498
RE: SQL is the first Language i am learning..how do i practice it ?? Pls Guide me..

Grant Fritchey (2/5/2013)
Best way to learn the basics is by doing. You've already been pointed out how to get a copy of SQL Server to play with. Next up, a...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

February 5, 2013 at 9:07 am

#1584456
RE: SQL is the first Language i am learning..how do i practice it ?? Pls Guide me..

If you want to learn the general SQL then you can get whatever your book is using,
lots of open source DB's and I think all vendors have an express...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

February 5, 2013 at 8:21 am

#1584415
RE: Backup Time for 2 TB DB

I used Litespeed on a 2005/2008 R2 SQL Cluster. Like many mentioned a lot of factors, disk IO being a major part. Native backup would have never worked out...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

February 5, 2013 at 7:32 am

#1584377
RE: CSV to Excel

Did you specify the double quotes as the text qualifier? if not it'll read the comma's inside the quotes...
example:
"test, test1,test2","xyz name","some id"
will read:
Col1 Col2 ...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 26, 2013 at 10:46 pm

#1581355
RE: Solar winds for a server

anthony.green (1/23/2013)
Solarwinds, is primarily a network monitoring tool but has branched out into a IT Management & monitoring solutions
http://www.solarwinds.com/
I evaluated it a good few years ago now and it wasn't...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 23, 2013 at 8:06 am

#1580111
RE: Consolildation plan

I think everyone else has iterated the same thing. What is the actual goal of the migration? That would help in determining a strategy. If you're goal is to...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 23, 2013 at 7:56 am

#1580108
RE: SSIS from 64 bit to a 32 bit machine, error on key not valid

Who's the owner of the package vs. the account that's running it? dtsx packages will ask for saved credentials if the person running it is different from the owner. ...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 23, 2013 at 7:18 am

#1580075
RE: CSV to Excel

MyDoggieJessie (1/22/2013)
Crude, but this will work, just loop through a directory (if you are able to execute xp_cmdshell, if not I'm sure there's a powershell script lingering around)DECLARE
...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 23, 2013 at 7:07 am

#1580064
RE: Join Values from 2 columns

I think this is what you're looking for...
Providing easily consumable sample data makes it easier for people to help and more likely...
--Setup Sample Data
declare @transactions as table (Receivers char(1), Payers...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 22, 2013 at 6:55 am

#1579612
RE: How to tell Version installed with only SSAS installed

This post may help:
http://www.sqlservercentral.com/Forums/Topic262014-17-1.aspx
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 16, 2013 at 7:25 am

#1577814
RE: Partition Splitting Problem<Changed>

ALTER DATABASE DBName ADD FILE
(NAME =F_TBL_201301,FILENAME ="<location>\F_TBL_201301.ndf",
SIZE = 50MB, MAXSIZE = unlimited, FILEGROWTH = 10%
) TO FILEGROUP FG_TBL
ALTER PARTITION SCHEME PS_TBL NEXT USED...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 16, 2013 at 7:19 am

#1577813
RE: Import Excel data into DB automatically using scheduler...but DataSource excel changes daily

Mykre (1/15/2013)
I have seen a system where it would look at a processed directory and process all of the files in that directory, when the package had finished with a...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

January 16, 2013 at 6:59 am

#1577807

Viewing 15 posts - 46 through 60 (of 131 total)